Forum Discussion
kg4u
Helper II
Helper IIMeasures with different dates
Hey PBI Community, I need some help. I do not know how to create 1 measure which uses a specific date and then create 2 measures using a different date. At the fundamental level I created 2 calend...
kg4u , you should use combination of Calculate and UseRelationship functions.
Use 1 calendar table and then using these functions define which metrics uses which date column for calculation.
Link: https://www.sqlbi.com/articles/using-userelationship-in-dax/
Cheers,
NemanjaYour solution worked perfectly for what I needed, thank you!
nandic
Resident Rockstar
Resident Rockstarkg4u , you should use combination of Calculate and UseRelationship functions.
Use 1 calendar table and then using these functions define which metrics uses which date column for calculation.
Link: https://www.sqlbi.com/articles/using-userelationship-in-dax/
Cheers,
Nemanja