Hi, I'm having trouble calling a variable in DAX ( assuming it is actually possible )...
I have a number of DAX statements similar to this:
d25:=CALCULATE([Creditx25],Data[Month]="32016",Data[PRODUCT]="Display")
Rather than changing "32016", I'd like to declare it as a variable, LMonth:="32016"
I've tried several ways of calling it, but all I get is errors...
d25:=CALCULATE([Creditx25],Data[Month]=[LMonth],Data[PRODUCT]="Display")
d25:=CALCULATE([Creditx25],Data[Month]=LMonth,Data[PRODUCT]="Display")
d25:=CALCULATE([Creditx25],Data[Month]='LMonth',Data[PRODUCT]="Display")
d10:=CALCULATE([Creditx10],Data[Month]=([LMonth]),Data[PRODUCT]="Display")
Thanks
Gav
I have a number of DAX statements similar to this:
d25:=CALCULATE([Creditx25],Data[Month]="32016",Data[PRODUCT]="Display")
Rather than changing "32016", I'd like to declare it as a variable, LMonth:="32016"
I've tried several ways of calling it, but all I get is errors...
d25:=CALCULATE([Creditx25],Data[Month]=[LMonth],Data[PRODUCT]="Display")
d25:=CALCULATE([Creditx25],Data[Month]=LMonth,Data[PRODUCT]="Display")
d25:=CALCULATE([Creditx25],Data[Month]='LMonth',Data[PRODUCT]="Display")
d10:=CALCULATE([Creditx10],Data[Month]=([LMonth]),Data[PRODUCT]="Display")
Thanks
Gav