Forum Discussion
DAX measures , same logic , different results
Hello community, I created the Diff-1_Pallets and Diff-2_Pallets measures , in order to calculate the differences between the latest extraction set vs the previous one, and between the latest ext...
HI Anonymous.
Any update for these? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hello Anonymous
Thank you for your reply.
Below you can find a shorter version of the Shipments table and a screenshot of my data model.
The screenshot found at my initial message shows the results filtered to the status RU.
IndexExtraction DateStatusShipment dateSum of Pallet_Num
| 1 | 15/11/2021 | RU | 04/11/2021 | 6 |
| 1 | 15/11/2021 | RU | 03/01/2022 | 4 |
| 1 | 15/11/2021 | RU | 17/01/2022 | 4 |
| 1 | 15/11/2021 | RU | 25/04/2022 | 4 |
| 2 | 02/11/2021 | RU | 05/11/2021 | 6 |
| 2 | 02/11/2021 | RU | 10/01/2022 | 4 |
| 2 | 02/11/2021 | RU | 31/01/2022 | 4 |
| 3 | 26/10/2021 | RU | 02/11/2021 | 6 |
| 3 | 26/10/2021 | RU | 10/01/2022 | 4 |
| 3 | 26/10/2021 | RU | 31/01/2022 | 4 |
Hope this helps.
George