undefined

Anonymous — Fri, 12 Jul 2019 12:39:07 GMT

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:

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

topic undefined in DAX Commands and Tips

undefined

Re: undefined