Forum Discussion

Kashinoda's avatar
Kashinoda
Advocate I
8 years ago

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 ...
AlbertoFerrari's avatar
AlbertoFerrari
Most Valuable Professional
8 years ago

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

Kashinoda's avatar
Kashinoda
Advocate I
8 years ago

Hello AlbertoFerrari! I recently received your Definitive Dax book, obviously not far enough through yet!

 

Thanks for pointing me in this direction, because the matter was urgent we solved the issue in SQL before building the model. I'll be recreating the issue in a test environment and will update this thread accordingly.