% difference from

[hasanpkb]

Hi all,

We have sales data from 2002 to 2018

the data per year is variety from 2.700 rows to 72.000 rows

Sales by date (every day)

We have already create chart from monthly to yearly summarized data using sum function.

How can we create chart that show% difference from

year to previous year?

or

month to previous month?

How do we know in what year, the sales revenue is growth more than 20% from previous year?

How do we know in what month, the sales revenue is growth more than 20 % from previous month?

Please help...

Thank you very much...

[v-yuta-msft · Accepted solution]

Hi hasanpkb,

To be general, you should firstly achieve the total value in your previous company fiscal year and recent company fiscal year using measures. There're built-in dax functions in power bi like DATEADD(), PREVIOUSYEAR(), SAMEPERIODLASTYEAR(), TOTALYTD() which can let you achieve the previous year value based on your senario.

You may also refer to this blog: https://blogs.msdn.microsoft.com/analysisservices/2010/04/12/time-intelligence-functions-in-dax/ .

Regards,

Jimmy Tao

[hasanpkb]

@v-yuta-msftThank you very much....