Forum Discussion
DAX measures , same logic , different results
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
Continued ContributorAnonymous
The only difference is with the field PreviousDataSet and OldestDataset.
I would build two tables using Week + PreviousDataset and Week + OldestDataset. Then, you can compare where the difference is.
When you filter the Week from the Date table, it will filter the Shipment table. So maybe, when the rows are filtered, sometimes, you will have 3 dates with 3 index so in this case MAX( Index) and Current+1 won't return the same value.
If Current is 1 then MAX( Index) will return 3 and the other one 2.
thank you m3tr01d and apologies for my late reply, will do that and get back to you