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 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

 

Need Help

5 Replies

  • 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