Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Monthly Restriction

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      Yes, I have created Dynamic Row Level Security. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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