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(
LOOKUPVALUE(Table[NetSales], Table[HalfYear], Table[HalfYear] - 100)
EVALUATE ADDCOLUMNS(Table, "LY", Table[LY])
Create a column with [date-field].[month] to fetch ...READ MORE
Need help in the problem faced in ...READ MORE
You can go through this:
PMYTD = ...READ MORE
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
Already have an account? Sign in.