Forum Discussion

diogofma89's avatar
diogofma89
New Member
4 years ago
Solved

group values difference dates range

Hi, I have a column with dates in my dataset and another one (calculated column) that gives me the difference of days between today and the date of the first column mentioned. I've tried to use  th...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi diogofma89 ,


    Refer to the following test to see if it meets your needs.

    Col_group =
VAR a = 'Table'[day_diff]
RETURN
    IF ( a > 0 && a <= 90, "group1", IF ( a > 90 && a <= 180, "group2", "group3" ) )
    day_diff = DATEDIFF('Table'[Date],TODAY(),DAY)

     

    If the problem is still not resolved, please indicate and provide a screenshot of the results you expect. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi diogofma89 ,


Refer to the following test to see if it meets your needs.

Col_group =
VAR a = 'Table'[day_diff]
RETURN
    IF ( a > 0 && a <= 90, "group1", IF ( a > 90 && a <= 180, "group2", "group3" ) )
day_diff = DATEDIFF('Table'[Date],TODAY(),DAY)

 

If the problem is still not resolved, please indicate and provide a screenshot of the results you expect. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

diogofma89's avatar
diogofma89
New Member
4 years ago

Hi v-henryk-mstf , thank you so much, it worked perfectly! 

Best regards