Forum Discussion
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...
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
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)