Multiple Date in the fact table

[ABideImen___28]

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 this dax formula but it shows me empty columns:

CALCULATE( SELECTDVALUE(Dim_Time[Date] , USERELATIONSHIP( Fact[id_date_Finish] , Dim_Time [id_time])

I hope you can help me please.

[Anonymous]

Hi  @ABideImen___28 ,

You might consider creating a custom matrix with custom layouts for the columns of the matrix.

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...

https://community.powerbi.com/t5/Desktop/Matrix-column-header-label-custom-group/td-p/1253196

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ABideImen___28]

@amitchandak  Can you help me please 😞 

[ABideImen___28]

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

[NickolajJessen]

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]

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

[NickolajJessen]

[Shishir22]

Hello @ABideImen___28 ,

Can you please share sample data and expected result.