Forum Discussion
Multiple Date Fields
I have a table that looks like this: Using a single date slicer, I would like to see the amount of companies created and the amount of companies closed within a selected date range. The g...
Thank you JasonTX ! I did figure out a way to get it by searching through another thread. Highlighting both date columns in the query editor, then unpivoting those columns did the trick. Then I have a single date column from my main table connected to my date table, and an additional column that allowed me to toggle between Close Date and Created Date. This is allowed me to write the following measures:
And this ended up giving me what I was looking for. I appreciate all your help! You as well v-yuta-msft !
Draw an inactive relationship between CreatedDate and your date in the date table.
Revaluate your measure by using something like:
Calculate(<expression>, USERELATIONSHIP('table'[CreatedDate], 'Datetable'[Date]))
Please let me know if this works!