Forum Discussion

ksteever's avatar
ksteever
Helper I
2 years ago
Solved

Card show between two relative dates

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)

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.