Forum Discussion

Post Prodigy

1 year ago

Solved

New Column Max Date

Hi Good Day,

Can anyone help me on my calculated column. I want to add calculated column that will show only the max date of may Date column.

DESIRED OUTPUT

Thank you

Irwan
1 year ago
hello AllanBerces

please check if this accomodate your need.

Hope this will help.

Thank you.
AllanBerces - 7Apr25.pbix47 KB

4 Replies

Irwan
Super User
1 year ago
hello AllanBerces

please check if this accomodate your need.

Hope this will help.

Thank you.
AllanBerces - 7Apr25.pbix47 KB
- AllanBerces
  Post Prodigy
  1 year ago
  Hi Irwan thank you very much, all good.
  - Irwan
    Super User
    1 year ago
    hello AllanBerces
    
    glad to be a help.
    
    Thank you.
v-nmadadi-msft
Community Support
1 year ago
Hi AllanBerces,
Thanks for reaching out to the Microsoft fabric community forum.

I used the following DAX expression to achieve the desired outcome.

Max date = VAR maxDate = CALCULATE(MAX('Table'[Progress Date]), ALL('Table')) RETURN IF('Table'[Progress Date] = maxDate, maxDate, BLANK())

Reference article on Max Dax command: MAX function (DAX) - DAX | Microsoft Learn
Reference article on IF Dax command: IF function (DAX) - DAX | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

Related content