Forum Discussion
creating a sales difference
Dear I really need your intelegence! I need your help! I will tell you what i want at the end, plz bear with me, brothers and sisters. I have a table called " source" colmun A is "Date" containin...
salmanalisalman , You can create a dax measure for this
Sales Difference =
VAR CurrentDate = 'source'[Date]
VAR CurrentBranch = 'source'[Branches]
VAR PreviousSales =
CALCULATE(
SUM('source'[Sales]),
FILTER(
'source',
'source'[Branches] = CurrentBranch &&
'source'[Date] = DATEADD(CurrentDate, -1, MONTH)
)
)
RETURN
IF(
ISBLANK(PreviousSales),
BLANK(),
'source'[Sales] - PreviousSales
)
