Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |