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
{"ft_lang_label":"__label__en","ft_lang_prob":0.71467316,"math_prob":0.76871127,"size":1199,"snap":"2021-21-2021-25","text_gpt3_token_len":321,"char_repetition_ratio":0.15648535,"word_repetition_ratio":0.0,"special_character_ratio":0.2618849,"punctuation_ratio":0.21132076,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9518281,"pos_list":[0,1,2,3,4],"im_url_duplicate_count":[null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-06-19T21:04:29Z\",\"WARC-Record-ID\":\"<urn:uuid:dfe9a30f-bb3a-4b10-a096-e2993fb81784>\",\"Content-Length\":\"135626\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:b235fd6c-9e7f-4aa0-988f-3d47c86464dc>\",\"WARC-Concurrent-To\":\"<urn:uuid:e7eab902-7fdd-4130-a711-cb4b237dbe06>\",\"WARC-IP-Address\":\"54.192.36.60\",\"WARC-Target-URI\":\"https://www.edureka.co/community/87062/dax-function-to-create-ly-measure-without-date-dimension\",\"WARC-Payload-Digest\":\"sha1:EZM5ZHF7P6YWL7H5ZYLJ22WIRKEESFPD\",\"WARC-Block-Digest\":\"sha1:DTQESGAI5T7FURMLLJ6OBCRMHYV3G5JY\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-25/CC-MAIN-2021-25_segments_1623487649731.59_warc_CC-MAIN-20210619203250-20210619233250-00398.warc.gz\"}"}