Forum Discussion
Multiple date columns in Fact table
my fact table has 4 date columns like as below i have created a caleder table and joined all 4, obviously 3 of them are inactive and only one is active. my ask is to have only one date slicer...
I don't quite understand what you need
If you selected 9/5/2012 , then what result are you expecting?
and if you choose 2/7/2024 then what are you waiting for
Ahmedx basically if i sleect one date, say like 9/5/2012, my below table should be filtered for the same date for those 4 date columns, inception date, submitted date, etc..
johnbasha33 , In this better not to join the date table and try like
Measure =
var _max = maxx(allselected(Date), Date[Date])
return
calculate([Your Measure], filter(Table, Table[Inception Date] =_max && Table[ResolutionDate] =_max)))
you can use OR (||) , also add other dates as per need
