Forum Discussion
Solved
DAX optimization: ValueMonth minus ValueMonthBefore
Hi all, i have the following measure that works fine. but is there a way to write it more compact? I have created two sepatated month and year tables and integrated the SELECTEDVALUE in the formu...
have a try with your connected Calendar
test = VAR CurSales = CALCULATE ( SUM ( Tabel1[Value] ), Tabel1[Categorie] = "A" ) VAR PreSales = CALCULATE ( SUM ( Tabel1[Value] ), Tabel1[Categorie] = "A", DATEADD ( Calendar[Date], -1, MONTH ) ) RETURN CurSales - PreSales
Hi Vera,
many thanks for your idea. Is it also possible to use the connected calender table and get rid of the separated year / month table? i think it will be than more difficult to show the previous month/year, right?
have a try with your connected Calendar
test =
VAR CurSales =
CALCULATE ( SUM ( Tabel1[Value] ), Tabel1[Categorie] = "A" )
VAR PreSales =
CALCULATE (
SUM ( Tabel1[Value] ),
Tabel1[Categorie] = "A",
DATEADD ( Calendar[Date], -1, MONTH )
)
RETURN
CurSales - PreSales
Great thank you 👍😊