Forum Discussion
Using DAX operators on multiple Dates from the same Fact table?
Hi Guys, This has been doing my head in a little. I have a Date Dimension Table and a Fact Table with multiple Date Columns. I wish to find an arbitary total, on the condition that DATE1 ...
USERELATIONSHIP is a bit harder to use in a calculated column. Instead, I would use just RELATED for one of the two columns (the one with the active relationship) and go for LOOKUPVALUE for the second one.
In this way, you can retrieve the two dates and perform the math.
You can find a detailed description of the scenario here: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/
Have fun with DAX!
Alberto Ferrari
http://www.sqlbi.com