Quarterly Trend

[Anonymous]

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 sales figures).

Please help me on the same.

 Regards,

Varun

[ryan_mayu]

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

Thanx Rayan.

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

[ryan_mayu]

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

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]

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

[AlB]

Hi @Anonymous

Is the amountyou're referring to the amount for the last day of the quarter? Or the cumulative for the last month in the quarter?

[Anonymous]

Hi, Its not the Cummulative amount, it is the amount of the last Day of the quarter

[Anonymous]

I Mean, the amount is the value of the sales as on end of the last month of the quarter