Remove from graph a measure that shows change if there is no initial period to compare with

[adriansuteu]

I have the current situation:

• data for sales from 2016 and 2017.
• a graph that show the Actual Revenue, Revenue growth from last Month and Revenue growth from the same month, previous year.

My issue is:

For the first year's (2016) Revenue = Revenue growth from the same month, previos year BECAUSE I don't have data for another previous year (2015) so it takes into consideration 0 as Revenue where it is missing data.

How can I avoid this and not show the result (Revenue growth from the same month, previos year) on the graph anymore?

The measures I used are:

Revenue ($) = sum(Orders[RevenuePerSale])

PY Sales ($) = [Revenue ($)](SAMEPERIODLASTYEAR('Calendar'[DateKey]))

Revenue Growth from Last Year = [Revenue ($)] - [PY Sales ($)]

And the graph contains both the Actual Revenue and the Revenue Growth from Last Year.

Thanks

[v-caliao-msft · Accepted solution]

@adriansuteu,

You can use the a IF function to check it current is the minimum year. If it's the minimum year, then return current month revenue, otherwise return previous year revenue.

PY Sales ($)=if(table[year]=min(table[year]),[Revenue ($)],[Revenue ($)](SAMEPERIODLASTYEAR('Calendar'[DateKey])))

Regards,

Charlie Liao