Forum Discussion
Helper IDAX - compare date field with another date field
I found the solution:
Resident RockstarHi fab,
It should work, you could have a try.
If you need further help, please share more details about your scenario, so that we can help further investigate on it?
If my reply help you, only thing that you'll have to notice, just always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
Helper IThank you for helping me,
Here are my questions (I changed tables names and add the product table):
The new "table" is no longer works:
then, I don't know how to link this table with the others tables to apply filters (for exemple, a product "color" filter)
(I don't know how to add an attachment to this post)
regards,
Fab
- v-piga-msft
Hi 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