Forum Discussion

ABideImen___28's avatar
ABideImen___28
Frequent Visitor
4 years ago

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...
Need Help
Tips and Tricks
NickolajJessen's avatar
NickolajJessen
Icon for Solution Sage rankSolution Sage
4 years ago

The reason you're having problems is because your datamodel is a mess 😞 
These 1-1 bidirectional filter between fact tables with screw you over big time, you don't get it right.

Consider wathing some best practive videos on datamodelling. I've used Avi Singh myself.

In you case you need to have a dimension table, that connects the etat and treso table on the ID-column

 

ABideImen___28's avatar
ABideImen___28
Frequent Visitor
4 years ago

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's avatar
    NickolajJessen
    Icon for Solution Sage rankSolution Sage
    4 years ago

    If 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