Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Days Group DAX Function

Hi, Can you please help me with DAX formulas, I kinda stuck.    I have START Date and END Date and need to calculate Days Between, I used this function below to create new column: Days = DATEDIFF...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous，

    Please try to create one calculated column as below:

    Days Group = IF ( ISBLANK ( [Days] ), "Pending", IF ( [Days] >= 6, "6+", [Days] ) & " Days" )

    If the above formula is not applicable in your scenario, could you please explain which condition can be grouped as " Pending "?

     

    Best Regards

    Rena