MoM, QoQ & YoY Change in Value with %

[Ketan_ashiyani]

Dear Team,

We need Dax formula for MoM, QoQ & YoY Change in Value with % as per Financial in Power BI Software

 

[Abdmujib]

This is for YoY

you might be able to the MoM and QoQ from that

YOY % Sales =
VAR PrevPer = CALCULATE([Total Sales ($)],SAMEPERIODLASTYEAR(dDate[Date]))
RETURN
    If(
        HASONEVALUE(dDate[Year]),
        DIVIDE([Total Sales ($)]-PrevPer,PrevPer
        )
    )

 

[Abdmujib]

Any progress?