Forum Discussion

FridolinWeiner's avatar
FridolinWeiner
Frequent Visitor
3 years ago
Solved

Reverse Waterfall substracting deadlines

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:

Total6
2023/01/014
2023/01/021
2023/01/030


Any Ideas how to accomplish this?

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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