Forum Discussion
Avivek
Post Partisan
4 years agoNeed help with Dax
Hi,
I'm facing the issue with dax,
I wrote a measure that giving last order date respective of particular tag id.
meanwhile using order id from the tag table, its returning all the order id's. But actually it should return only one Order ID, which would be the last order date based on my measure.
Max OrderDate = MAXX(FILTER('Tag Usage Fact','Tag Usage Fact'[Tag ID]='Consignment Fact'[Tag ID]),'Tag Usage Fact'[Date DD/MM/YYYY]).
similarly when there are different order owners the date records repeat for every different order owner. Bit it should be ideally showing just one record.
Actually my result should be as shown below but including the above 3 mentioned columns.
1 Reply
- AnonymousNot applicable
Can you please share the sample data with the output that you are expecting.