Forum Discussion
Kristoff15
1 year agoRegular Visitor
Universal Date Slicer
Hello, I am looking for suggestions regarding my current scenario. I have a table let's call it Task and it has two separate dates CreatedDate and ClosedDate. I have certain reports that measures...
- 1 year ago
You'll create 2 relationships from your date table to your task table. One will be inactive then use the USERELATIONSHIP dax function to call the other date. Check out this article.
https://www.sqlbi.com/articles/using-userelationship-in-dax/
Kristoff15
1 year agoRegular Visitor
I'm suprised it would be this easy! thank you so much it works!