Forum Discussion
Multiple Date in the fact table
hi Shishir22 thanks for replying me
Here is my first Fact Table that contains id_date_first and id_date_end :
My second fact containt id_date_encaissement :
here is the schema both fact tables are related to Dim_Time and only one relationship is active between them ( there is another dimensions that why there is so many relationship in the schema) :
And i tried this measure to retrieve the finished date :
and here is what it shows ( blank) ( the first date is showen because the relationship is activet):
I hope you help me
Solution SageThe 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
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
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