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.
Power BI All Stars:
I have 10 years worth of sales data - seeking help with calculating the percentage change for current month (November 2017) over same month last year (November 2016). Also, is there a way to calculate YTD %'age change - e.g., Jan - Nov 2017 versus Jan - Nov 2016?
Thank you for helping a Power BI novice! ~DentonBlake
Solved! Go to Solution.
Dentonblake
1. Exclude from the table the columns [total_recipets], [TABC_SALES], [Quarter], [Day]
Do not forget that the KPI you created is monthly, any column you use can lead to inconsistencies in the data.
And the most appropriate filter is YEAR.
Include a YEAR SEGMENTATION.
It will get better.
if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
Best Regards,
Rfranca
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |