Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |