undefined

[ruta]

Hi all,

I am having trouble filtering out biggest (most recent date). What I need to do is quite simple: I have columns : Debt and Date. I want to add the debt column after filtering it by date columnm, so it only adds the numbers (debt) of the most recent month. 

I  tried to do it in a following way:

1) 

LatestMonthBD = IF('as of 6 30 2019'[As of date] = max([As of Date].[MonthNo]), 'As of 6 30 2019'[Bad Debt Reserve (USD)], 0)

2) Adding a measure sum(latestMonthBD)

However, the IF does not work because it returns 0 for all months. Any idea why? Or how I could do it alternatively? I will also need a second to largest day( aka previous month) sum, not sure how to filter it out either.

Any help is appreciated

Cheers,

Ruta

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best

Darek