Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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
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
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |