Forum Discussion
Multiple date columns in Fact table
one approach you can take is to unpivot your table so that you will have :
datetype with values { inceptiondate, resolutiondate , submitteddate a, dateoflastupdate )
and the second column is the dates .
this way you will have one date column to link to your dimdate and the other column specifiyin the type of the date on the current row .
this can be done in power query under transform --> unpivot columns.
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Daniel29195 Hi, thanks for taking your time to respond, the problem is, i am using existing semantic model as my source in the report, i dont have any control as it is direct query and we cant ask for import mode due to sensitivity issues. looks like it is not possible?
you can maybe ask the backend team to unpivot the table for you , but keep in mind that the nb of rows of this table would be multiplied by 4 .
other than this, im not sure if you can achieve your requirement in another way .
plus, since each column consist of a different business logic, so it is not ideal to have one slicer that filters all of them, unless you can specify what type of date you are filtering on . ( thus you need to unpivot your table )
hope this makes sense.
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
