Alternate of Time intelligence function (DATESBETWEEN and DATESINPERIOD)

[Anonymous]

Hi,
I am using DATESBETWEEN for previous days calculation. 
for eg. in date slicer i have selected date from 01/07/2021 and 10/07/2021 (10 days)
then as per the logic measure will do the calculations for previous 10 days ie. (21/06/2021 to 30/06/2021)

But I am using RSL and because of this measure is not working,
is there any way to replace this time intelligence function.

[Anonymous]

@selimovd Thanks for your reply 

I have the date 

Created the date table based on this table

date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

and the measure using here is 

KPIs = CALCULATE(DISTINCTCOUNT('Table'[KPI ID]))

Start date = MIN('date'[Date])

End date = MAX('date'[Date])

Prev Start Date = [Prev End Date]- (DATEDIFF([Start date],[End date],DAY))

Prev End Date = [Start date]-1

Prev KPIs = CALCULATE(DISTINCTCOUNT('Table'[KPI ID]),

                    DATESBETWEEN('date'[Date],[Prev Start Date],[Prev End Date]))
I am facing problem in Prev KPIs, this is working fine here but i am using RLS on Agent id so the DATESBETWEEN is not working 
I used the below measure 

Prev KPIs = CALCULATE(DISTINCTCOUNT('Table'[KPI ID]),

                   REMOVEFILTERS('date'[Date]),

                 FILTER('Table','Table'[Date] >= [Prev Start Date] && 'Table'[Date] <= [Prev End Date]))
but the result is blank

[v-xiaotang · Accepted solution]

Hi @Anonymous 

https://docs.microsoft.com/en-us/dax/removefilters-function-dax#remarks

please try function ALL(),

https://docs.microsoft.com/en-us/dax/all-function-dax

Best Regards,

Community Support Team _ Tang

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

[Anonymous]

All function is working in RLS but in document its written that

[selimovd]

Hey @Anonymous ,

we all don't know your data model and your measures.

So we cannot tell you why things are not working and how to fix that.

Share more information and you will get help here in the community.

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic