Reverse Waterfall substracting deadlines

[FridolinWeiner]

Hello!

I have a list of expiry dates and want to create a Waterfall that starts with a count of all expiry dates after today substracting the count of expiry dates.

If I use Category "Expiry date" and Y-Axis "Count of Expiry Date" I get the visual I need but starting with zero today and the full value when the last expiry date hits. I need this Starting with the highest value substracting the count for every date.

Expiry Date

2023/01/01

2023/01/01

2023/01/02

2023/01/02

2023/01/02

2023/01/03

Should show me:

Total	6
2023/01/01	4
2023/01/02	1
2023/01/03	0

Any Ideas how to accomplish this?

[Anonymous · Accepted solution]

Hi @FridolinWeiner,

So you mean to get the coming expiry date counts based on current date? if that is the case, you can modify the condition to larger than current date.

formula =
VAR currDate =
    MAX ( 'Table'[Date] )
RETURN
    COUNTROWS ( FILTER ( 'Table', 'Table'[Date] > currDate ) )

Regards,

Xiaoxin Sheng