Forum Discussion

siemdevlieger's avatar
siemdevlieger
Helper I
2 years ago

Handling table (visual) with multiple date fields

Hello,   I am facing an issue for which I have not yet found a resolution, hope someone here can help.   Point of view: Working on a dashboard for tenders, for each tender we have a 'submission ...
Need Help
Show and Tell
Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello siemdevlieger ,

 

you need to have a dim date table that is linked to both dates, one of them should be active and another should be inactive because you can have one active relationship between the tables.

 

then you activate the second relationship in the dax measure using the Userelashionship dax function.

 

check this https://youtu.be/eiDWMqgKlZI?si=rcaBOz82gHaUz0PF

 

  • siemdevlieger's avatar
    siemdevlieger
    Helper I
    2 years ago

    Hi Idrissshatila ,

     

    first of all thanks for your reply and taking the time here.

     

    I already use this solution in my measures, and this is working fine. However, I would now like to show 2 lists in my report. One of the tables should show a list with all submitted tenders in the period. The other list should be a list (not a measure but a list with all tenders) with all awarded tenders that were won on this period (based on award_date).

     

    That's the part I am struggling with. Will need to see if the other opted solution might work, see below what I am trying to do 

     

     

    Thanks again!

     

    Best regards,

    Siem