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, 2020 in Power BI by anonymous
• 8,880 points
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 Gitika
• 65,910 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,970 points
99 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
205 views
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

answered Oct 7, 2020 in Power BI by Gitika
• 65,910 points
507 views
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, 2020 in Power BI by Gitika
• 65,910 points
106 views
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

answered Sep 24, 2020 in Power BI by Gitika
• 65,910 points
253 views
0 votes
1 answer

Understanding the DAX CALCULATE function

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

answered Sep 28, 2020 in Power BI by Gitika
• 65,910 points
197 views
0 votes
1 answer

DAX EARLIER() function in Power Query

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

answered Oct 1, 2020 in Power BI by Gitika
• 65,910 points
387 views
0 votes
1 answer

DAX Userelationship function

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

answered Oct 5, 2020 in Power BI by Gitika
• 65,910 points
130 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

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

answered Oct 27, 2020 in Power BI by Gitika
• 65,910 points
99 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, 2020 in Power BI by Gitika
• 65,910 points
525 views