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

      • Satish_Kumar's avatar
        Satish_Kumar
        Helper V
        9 years ago

        Hi v-yulgu-msft,

         

        Thanks for the article i will keep this in mind before posting next time.

         

        Actully if i talking about the scenario, I have to compare YOY and for that then i have to apply the filter of financial year.

        And when we applied the filters the data get shorted according to that but the "CARD" chart is fix for only one measure

        and it show only value that was calculated.

        And if i want to see the comparison of two different year which i select through filter then the "CARD" should show the result depending on the filter selection.

        So for that i need two variable where i can store the filter values and remainning calculation will be done according to the years stored in the variables.

        Currenty i just fixed the card with a two years (can say i just made it static) and when i select random value then it show me null.

         

         

         

         

         Regards,

         Satish Kumar