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.
Dear Kudos
I am converting an old Excel file report to the BI.
The old Excel file has many customized columns and cells.
One of my missions is to create measures for the following tables.
Factory | Operation | Last Year Total | Last 13 Month by Month | Current Year Total | Current Year Avg.
Above the list is the column header.
The production data refers to many different database files.
So there are many rows that measures are not coming from one table.
Order
Production
Stock
Priority
And so on...
So it is not easy to create the table. Furthermore, I would like to change the month and year based on the date slicer.
For example, if I select 2023/Oct by the date slicer, the report should show
Factory | Operation | 2022 Total | 2022 Oct - 2023 Oct by month | 2023 Total | 2023 Avg.
Order
Production
Stock
Priority
Is there a proper approach to make this kind of complicated table by Dax measure?
Solved! Go to Solution.
hi, @Young_G_Han
There no direct posiibility to create such things but you can make a new measure for selected year and make card visual and overlap it in measure or column name
like below
make new measure for selected year only
here yellow color is card visual after resize it and red color is measure name
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi, @Young_G_Han
There no direct posiibility to create such things but you can make a new measure for selected year and make card visual and overlap it in measure or column name
like below
make new measure for selected year only
here yellow color is card visual after resize it and red color is measure name
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear Dangar332
Nice idea. I supposed that would not be easy.
But your idea is reasonable.
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 |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
69 | |
47 | |
46 | |
20 | |
16 |