87062/dax-function-to-create-ly-measure-without-date-dimension
Is there a DAX Function I can use for my issue? To get LY I have to subtract 10 from HalfYear. There´s no date dimension. It should show Net value among HalfYear dimension e.g. 20121 (Year+HalfYear 1 or 2). How do I create such a measure?
Thanks in advance!
It should be fairly simple (sumx of lookup to old year value). DAX-wise it goes like:
DEFINE MEASURE Table[LY]=SUMX( Table, LOOKUPVALUE(Table[NetSales], Table[HalfYear], Table[HalfYear] - 100) ) EVALUATE ADDCOLUMNS(Table, "LY", Table[LY])
Hi, Create a column with [date-field].[month] to fetch ...READ MORE
To convert the LossValue column into a ...READ MORE
You can go through this: PMYTD = ...READ MORE
Try this: Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage]) An alternative ...READ MORE
You can make use of this: MTD Budget ...READ MORE
Using the CALCULATE function makes the DAX perform a context ...READ MORE
Solutions in the code below. Notice that ...READ MORE
You need a way for the measure ...READ MORE
The following steps make your task simple ...READ MORE
You could make [Measure12] return the same results as ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.