Forum Discussion
Helper IDAX - compare date field with another date field
I found the solution:
Resident RockstarHi fab,
You can upload your dummy pbix file to OneDrive or Dropbox and post the link here. (Do mask sensitive data before uploading.)
Best Regars,
Cherry
- v-piga-msft
Hi fab,
From your data model, the error is caused the duplicate values in current date column. Since the LOOKUPVALUE function is only expecting a single column with one unique or distinct value.
Now, your data model is differently from the first post, could you show me your desired output?
Best Regards,
Cherry
fabHello,
I would like the same table as my first question:
current date - amount current date - amont compare date
1/1/2017 - 210 - 15
2/1/2017 - 225 - 12
3/1/2017 - 12 - 26
4/1/2017 - 29 - 35
5/1/2017 - 15 - 296/1/2017 - 26 - 29
7/1/2017 - 8
8/1/2017 - 35
I would like this table dynamically, if I want to add the color or the product, the good agregate amount must be displayed.
The real model contains several other tables....
fab
- fab
I found the solution: