Forum Discussion
Clarification Needed: Time Intelligence DAX Won't Work in RLS?
I'm reading up this statement in almost all time intelligence DAX tutorials. This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS)...
Hi yyzheng12 ,
That statement means : If you are using Direct Query Mode or RLS, you cann't use the Time Intelligence function in the DAX expression of RLS rules or calculated columns.
For more details, please refer to:
DirectQuery in Power BI - Power BI | Microsoft Learn
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.