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.
Hello Community,
I am experiencing difficulty creating a DAX Command that compares my monthly averages and percentage changes. I need to see all-time average rather than the average for the month. I will include the information below. I need to display the % change in a table with the following columns:
Product Identification, (All time - 2022-9), (All time - 2022-10), and % change.
I do not own the live dataset.
Any help would be greatly appreciated. I will provide images below.
Thank you!
Best,
Hi, @PowerBiGuru2
I failed to complete the understanding. What do you expect the output to be? Is it possible to expand your sample data and expected output in Excel?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-zhangti,
Thank you for your response. I have attempted building Excel pivot tables to accomodate my needs. Unfortunately, that was not ideal as my "... code" would not match the two separate date ranges.
I have provided an image below to further identify my objective:
Due to keeping the anonymity, "... Code" serves as my replacement identifier (highlighted in black). In yellow are the numbers I need to compare in order to output a % change. The logic would be as follows:
"A12... Code" All time - September = 4.71 All time - October = 4.71 4.71-4.71 = 0 0/4.71 = 0.00%
The 0.00% should be the new column output.
Thank you!
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |