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 

 

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)