Forum Discussion
Super UserMultiple date columns in Fact table
Super UserDaniel29195 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?
Community Championyou 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! 🤠