group values difference dates range

[diogofma89]

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  the data group option in PBI, but today i have a list of values of difference of days and tommorow I will have another one. So, I wonder if there is any possibility to group by range of difference of days.

Can anyone help me out with the best solution?

Thanks 

[v-henryk-mstf · Accepted solution]

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]

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

Best regards

[diogofma89]

@amitchandak , thanks for the reply, I just want to have a date slicer of one column and I would like to have a filter based on the difference of days between the date of that column and today, but instead of having a filter with numbers I would like to group the range of numbers with a specific text, like, from 1 to 90 "less than 3 months".

[amitchandak]

@diogofma89 , Can two date/period slicer can help

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg