Forum Discussion
Measures 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 calendars, and the data results were correct when I used both calendars, however, now I can't figure out how to use the calendars to display the data. I think I need some more complex measures. Do you have any ideas on how to resolve my problem?
My measures are very simple.
Total Applications = SUM('Fact Data'[Applications])
Total Policies = SUM('Fact Data'[Policies])
Total Sales = SUM('Fact Data'[Original Sales])
Applications needs to use the Entry Date column, highlighted with the red box.
Policies and Sales need to use the Conversion Date column, highlighted with the red box.
Here is a snip of the Fact Data
How can I sum Applications using Entry Date?
How can I sum Policies and Sales using Conversion Date?
Thank you!
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!
2 Replies
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!