Forum Discussion

hasanpkb's avatar
hasanpkb
Frequent Visitor
7 years ago
Solved

% difference from

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 summarize...
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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