Forum Discussion
Multiple Date in the fact table
Hello , I have a fact table containing the IDS of 3 date: start date, end date and collection date and dimension Dim_Time I want to make a matrix that displays the 3 dates and I can't do it, I tried...
Hi NickolajJessen thanks for answering me
I remodeled my star model and I rectified the relationship between the fact table and the dimension by choosing a one-way and one to many relationship and the dax expression still does't work i hope you can suggest me another solution or dax expression 😞
NickolajJessen
Solution Sage
Solution SageIf you have an DIM ID table to conntect the two tables, you don't really need any dax.
Just drag and drop field onto a visual