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,
I used the following formula to calculate the delta between to version:
Planning version | Planning date | Planning groupe | Value |
1 | 01/01/2022 | Citybike | 10 |
1 | 01/01/2022 | Mountain bike | 20 |
1 | 01/01/2022 | Race bike | 50 |
1 | 01/01/2022 | Cross bike | 40 |
2 | 01/01/2022 | Citybike | 20 |
2 | 01/01/2022 | Mountain bike | 50 |
2 | 01/01/2022 | Race bike | 5 |
1 | 02/01/2022 | Citybike | 15 |
1 | 02/01/2022 | Mountain bike | 25 |
1 | 02/01/2022 | Race bike | 55 |
1 | 02/01/2022 | Cross bike | 45 |
2 | 02/01/2022 | Citybike | 20 |
2 | 02/01/2022 | Mountain bike | 50 |
2 | 02/01/2022 | Race bike | 5 |
In the result i am missing the delta for Cross bikes.
Can any one help me?
PBIX file: https://drive.google.com/file/d/1-S9nAhHpFyldQVtlOulMqPLxhhEq8tvP/view?usp=sharing
Regards,
Paul
Solved! Go to Solution.
Hi, @theunissenp
It is recommended to add a separate dimension table:
Planed version = DISTINCT(Test[Planning version])
In the matrix visual, you need replace field 'Planned Version' in fact table with field 'Planned Version' in new dimension table.
Best Regards,
Community Support Team _ Eason
Is there any one who can help me?
Hi, @theunissenp
It is recommended to add a separate dimension table:
Planed version = DISTINCT(Test[Planning version])
In the matrix visual, you need replace field 'Planned Version' in fact table with field 'Planned Version' in new dimension table.
Best Regards,
Community Support Team _ Eason
Thanks for your reply. I added the table but the delta formula is not giving any value for the delta for Cross bikes...
Delta formula:
Hi @theunissenp
Asking a question that might drive you to find solution. What is the expected results based on this sample?
Currently, the delta for cross bikes is missing. This is missing because this planning group is not planned in both versions. I want to show it anyway.
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
51 | |
44 | |
16 | |
12 |