Card show between two relative dates

[ksteever]

I am building a dashboard for workload/project forecasting that I want to show a count of instances with a date <30 days (Easy/done that) between 31 and 60, and over 60. What's the best way to do this (trying to avoid adding additional columns to my data set, I already have 100,000 cells of data)

[Anonymous · Accepted solution]

Hi @ksteever ,

Please try to create measure and add it to the card visual, dax formula like below:

CountLessThan30Days = CALCULATE(
        COUNTROWS('YourTable'),
        DATEDIFF('YourTable'[YourDateColumn], TODAY(), DAY) < 30
    )

CountBetween31And60Days = CALCULATE(
        COUNTROWS('YourTable'),
        DATEDIFF('YourTable'[YourDateColumn], TODAY(), DAY) >= 31,
        DATEDIFF('YourTable'[YourDateColumn], TODAY(), DAY) <= 60
    )

CountMoreThan60Days = CALCULATE(
        COUNTROWS('YourTable'),
        DATEDIFF('YourTable'[YourDateColumn], TODAY(), DAY) > 60
    )

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.