Forum Discussion
ashishg
Advocate I
Advocate INeed 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
Super User
Super UserIf 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 )
ashishgAdvocate I
Advocate IThis was I'm doing but when I used my calculated column( month year like: Jan 2023) then the value shows the blank.