Latest Date Shows Blank

[JMacDonnell]

Hi, I am a little new to the world of power bi so sorry in advance if this is an easy one. I currently have this table, the case reference 11686917 contains 2 rows for last idbd date. 

I want to just show the most recent date so in the visualization I set Last idbd date to latest but it just displays blank not 2023-03-09

Any help on this would be greatly appreciated, if you need me to provide more info as well let me know

thanks 

Jay

[v-rzhou-msft · Accepted solution]

Hi @JMacDonnell ,

I suggest you to try ALLEXCEPT() function in your code.

Last idbd date = 
CALCULATE(MAX('Table'[IDBD Date]),ALLEXCEPT('Table','Table'[Case Reference]))

Result is as below.

Best Regards,
Rico Zhou

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

[amitchandak]

@JMacDonnell , Try a measure like

maxx(filter(table, not(isblank([last IDBD date])) ), table[last IDBD date])