Monthly Restriction

[Anonymous]

Hi Community,

I am pretty new to dax and your help will be appreciated.

I have created some power bi repots. now if a customer is monthly customer he can see the data only on the last day of month. for example if a customer is monthly customer when he logged in 1st of march he can able to see only until febrauary data not for march 1st. if he logged in 10th of march also he can able to see only until febrauary data.

I have no clue how to do it. 

thanks in advance!

Thanks,

Paruchuri

[v-yuezhe-msft]

@Anonymous,

What data would the user view if he logs in the date that is greater than 10th of March? In Power BI, you can compare today with the date you want and then display relevant data.

Please share dummy data of your table and post expected result here.


Regards,
Lydia

[Anonymous]

Hi Lydia,

Thanks for your reply. 

If i don't have montly restriction, If the user logs in he can view entire data until today but i want to restrict him to see only till last day of previous month.

Thanks,

Paruchuri.

[v-yuezhe-msft]

@Anonymous,

Do you have other policies for other users? Or do you create the report for this specific user?

If the report is used by different user, you need to define Row Level security. If you create the report for the specific user, you can create measure.

Regards,
Lydia

[Anonymous]

Yes, I have created Dynamic Row Level Security. 

[v-yuezhe-msft]

@Anonymous,

What is the problem do you get currently? You can create a measure using username() function to check if it returns specific user.

Regards,
Lydia