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

vivran22's avatar
vivran22
Community Champion
6 years ago

Hello Anonymous 

 

I would recommend to use Power Query for this:

 

Add a custom column:

 

Change the column type to number:

 

Add a conditional column:

 

Result:

 

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top šŸ™‚

https://www.vivran.in/

Connect on LinkedIn