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 Power BI Community,
I need a help with structuring a table and to do a variance analysis on product performance.
(PL tab specifically)
I would like the final table in PL tab to look like a table in below excel data.
I would like to be able to drill down in Power BI on column to get the detail of where the performance gap is coming from.
In the above dataset I have a lot of data, but I would like to focus on 2018 Jan - Mar on a brand called BIO.
I have several measures to calculate volume and Net Sales in CY (current year) and LY (Last year),
but beginning to think measures may not be the right way to approach this.
Perhaps, I need to unpivot the original dataset in query mode to have all values in one column like below screenshot.
If any of above is not clear, please let me know.
Your help is much appreicated.
Many thanks,
H
Hi @hidenseek9
Currently, i have unpivot the "volume and Net Sales" columns, the create a measure
Measure = CALCULATE(SUM(Sheet2[Value]),FILTER(Sheet2,[DATE].[MonthNo]>=1&&[DATE].[MonthNo]<=3))
I will update my reply nextday.
Best Regards
Maggie
Thank you Maggie.
I will wait for your response.
It will be great to do a variance analysis.
Thanks,
H
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |