DAX function to create LY Measure without date dimension

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 in Power BI by anonymous
• 3,400 points
26 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 by Gitika
• 42,520 points

Related Questions In Power BI

0 votes
1 answer

Measure to filter date from another field

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

answered May 17, 2019 in Power BI by Cherukuri
• 32,490 points
59 views
+2 votes
0 answers

How to create measure out of column

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

Aug 14, 2019 in Power BI by anonymous
• 230 points
140 views
0 votes
1 answer
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

answered Oct 8 in Power BI by Gitika
• 42,520 points
20 views
0 votes
1 answer
0 votes
1 answer

Understanding the DAX CALCULATE function

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

answered Sep 28 in Power BI by Gitika
• 42,520 points
43 views
0 votes
1 answer

DAX EARLIER() function in Power Query

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

answered Oct 1 in Power BI by Gitika
• 42,520 points
78 views
0 votes
1 answer

DAX Userelationship function

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

answered Oct 5 in Power BI by Gitika
• 42,520 points
25 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

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

answered 2 days ago in Power BI by Gitika
• 42,520 points
15 views
0 votes
1 answer

DAX Calculate function with and without FILTER

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

answered Sep 24 in Power BI by Gitika
• 42,520 points
62 views