Forum Discussion

ashishg's avatar
ashishg
Icon for Advocate I rankAdvocate I
3 years ago

Need Help for creating Month over Month % in Direct Query in PBI

Hello Guys,  Need help !!! I will be using DIrect query in power bi and my data source is azure synapse. i need to calculate month over month % in desktop.  I have order date and sales. so base...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You need to use REMOVEFILTERS on whichever table / column you are using in the visuals.

ashishg's avatar
ashishg
Icon for Advocate I rankAdvocate I
3 years ago

Can you please help me with DAX, or how we can modified above dax

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    If you're using columns from the date table in your visuals you could do something like

    MoM % =
VAR CurrentMonth =
    SUM ( Sales[Amount] )
VAR PrevMonth =
    CALCULATE (
        SUM ( Sales[Amount] ),
        DATEADD ( Sales[Order Date], -1, MONTH ),
        REMOVEFILTERS ( 'Date' )
    )
RETURN
    DIVIDE ( CurrentMonth - PrevMonth, PrevMonth )
    • ashishg's avatar
      ashishg
      Icon for Advocate I rankAdvocate I
      3 years ago
      This was I'm doing but when I used my calculated column( month year like: Jan 2023) then the value shows the blank.