Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Quarterly Trend

Hi All,   In the below Dataset, i wish to show the closing amount for every quarter end in a graph.   For example, in graph i wish to present the sales of Mar 1515, Jun16000 ( not the cummulative...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
7 years ago

Anonymous

 

I suggest you to use date instead of month name

 

Then creating a new measure as the screenshot below. Then you can get the result.

Hope this is helpful.

 

Thanks and BR

Ryan

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanx Rayan.

 

I'll try this and reach you incase of any help

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    7 years ago

    Anonymous 

     

    No problem. Please feel free to contact me if you have any questions.

     

    Please kinldy mark my previous answer as a solution if it totally solved your problem. Appreciate you can give me a Kudo as well.

     

    Thanks and BR

    Ryan

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Ryan,

       

      Thanx this code helps for me. by any chance ist possible to help with another code to define the % increase over previous period (Variance %).

       

      REgards,

      Varun

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        7 years ago

        Anonymous,

         

        You need to have a datetime table and use date column to build relationship with fact table and date table.

         

        PQ % =
        VAR PQ= CALCULATE([test],DATEADD('date'[Date],-1,QUARTER))
        return
        DIVIDE([test]-PQ,PQ)