0 votes

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! Oct 1, 2020 in Power BI 160 views

## 1 answer to this question.

0 votes

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])``` answered Oct 1, 2020 by
• 65,910 points

0 votes
1 answer

## Measure to filter date from another field

Hi, Create a column with [date-field].[month] to fetch ...READ MORE

+2 votes
0 answers

## How to create measure out of column

Hi, Need help in the problem faced in ...READ MORE

0 votes
1 answer

## DAX Previous Month to date total is giving entire previous month's entire total

You can go through this: PMYTD = ...READ MORE

0 votes
1 answer

## How do I get my DAX measure to calculate grouped values?

Try this: Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage]) An alternative ...READ MORE

0 votes
1 answer

## Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

0 votes
1 answer

## Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

0 votes
1 answer

## DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

0 votes
1 answer

## DAX Userelationship function

You need a way for the measure ...READ MORE

0 votes
1 answer

## How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

0 votes
1 answer

## DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE