Forum Discussion
How to turn multiple SQL joins into DAX? Example challenge
Help will be very much appreciated! Say if I want to create a measure called "Prior_Sales", now I have two tables I can use - [dim_date] and [sales]. The result should be: given a particular ISO...
Hi,
In the case of comparing weeks you could use variables.
If your data format is like you described somethin like this should do:
e.g. [measure] =var _ISOWEEK = MAX(Isoweeks[ISOWeek])var _LY_ISOWEEK = CONCATENATE(LEFT(_ISOWEEK,4)-1,RIGHT(_ISOWEEK,2))returnCALCULATE(SUM(Isoweeks[Value]),ALL(Isoweeks),Isoweeks[ISOWEEK]=_LY_ISOWEEK)Example data:
End result:
Hi,
In the case of comparing weeks you could use variables.
If your data format is like you described somethin like this should do:
e.g. [measure] =
var _ISOWEEK = MAX(Isoweeks[ISOWeek])
var _LY_ISOWEEK = CONCATENATE(LEFT(_ISOWEEK,4)-1,RIGHT(_ISOWEEK,2))
return
CALCULATE(SUM(Isoweeks[Value]),ALL(Isoweeks),Isoweeks[ISOWEEK]=_LY_ISOWEEK)
Example data:
End result: