Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Urgent Repeat last date

Hi all,

 

How can I apply the ID date for all fields?

In this case all rows must return 05/09/2019 if ID = 11 and 29/08/2019 if ID =16.

 

Thanks a lot!

 

Work Item IdNEW COMPLETED
11 
1105/09/2019 00:00
11 
16 
16 
1629/08/2019 00:00
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I found out by myself using the dax below. Thank you so much for trying to help.

     

    CALCULATE (

    MAX ( 'MEDIAS STATUS'[COMPLETED] );

    ALLEXCEPT ( 'MEDIAS STATUS';'MEDIAS STATUS'[Work Item Id])

    )

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    send sample data pbix and the desired result. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I found out by myself using the dax below. Thank you so much for trying to help.

       

      CALCULATE (

      MAX ( 'MEDIAS STATUS'[COMPLETED] );

      ALLEXCEPT ( 'MEDIAS STATUS';'MEDIAS STATUS'[Work Item Id])

      )