Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago

How to declare a variable?

Hi All,   I am facing some challenges in making dynamic filters in Power BI. I am making YOY% , QOQ% , YTD , QTD for our analytics.   For Example, we are using (Current Year(FY16-17)-Last Year(FY...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Similarly for QOQ, YTD & QTD, we have the same requirement. So kindly guide me as to what steps should I follow to achieve it.

 

 Specifically, what are you trying to achieve?

 

Can you send a picture of how your data is stored, or possibly create some sample data?

 

Best,

Martin

Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago

 

 

Anonymous 

This is what i want to achive.

 

Regards

Satish

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Satish_Kumar

     

    I understand. Did you have any success with it? I need to see a sample of how your data is stored in order to help you.

    • Satish_Kumar's avatar
      Satish_Kumar
      Helper V
      9 years ago

      Anonymous

       

      I just use the a table called "General Ledger Entry".

      And i am fetching the data from SQL database.

       

       

       

      Regards,

      Satish Kumar

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi Satish_Kumar,

         

        Please refer to this article to provide more useful information to illustrate your scenario, so that we can test for you.

         

        Regards,
        Yuliana Gu