topic Please help how to write dax for this situation in DAX Commands and Tips

Please help how to write dax for this situation

firstch — Fri, 08 Jul 2022 12:19:34 GMT

Hi all please help me with dax for this problem ,I want to show previous year price with this data

year	region	state	price
2019	mid	DC	900.00
2019	center	NY	900.00
2019	east	LA	900.00
2020	mid	DC	920.00
2020	center	NY	920.00
2020	east	LA	920.00
2021	mid	DC	950.00
2021	center	NY	950.00
2021	east	LA	950.00

I want to display this in correct way

I want to display on card with percent different of previous year
thankyou in advance
Best Regard
firstch

Re: Please help how to write dax for this situation

Anonymous — Fri, 08 Jul 2022 13:16:52 GMT

You need to use time-intelligence functions. You can solve this with PREVIOUSYEAR(), SAMEPERIODLASTYEAR(), PARALLELPERIOD, DATEADD, DATESINPERIOD. Here's a video that might guide you (not from my authoring 🙂 ) https://www.youtube.com/watch?v=lGBVOTqYb88

Re: Please help how to write dax for this situation

firstch — Fri, 08 Jul 2022 17:26:57 GMT

hi@ Raymundo2910 will PREVIOUS YEAR WORK? cause i didnt have date dimension

Best Regard

firstch

Re: Please help how to write dax for this situation

v-easonf-msft — Wed, 13 Jul 2022 07:47:21 GMT

Hi, firstch

Try formula like:

from last year = VAR Currenty = SELECTEDVALUE ( 'Sheet1'[year] ) RETURN CALCULATE ( average( 'Sheet1'[price] ), 'Sheet1'[year] = Currenty - 1, ALLEXCEPT ( Sheet1, Sheet1[region], Sheet1[state] ) )

Current Price = IF(ISFILTERED(Sheet1[year]),AVERAGEX(Sheet1,Sheet1[price]),BLANK())

diff = var a=[Current Price]-[from last year] return IF(ISBLANK([from last year]),BLANK(),a)

Best Regards,
Community Support Team _ Eason

Re: Please help how to write dax for this situation

firstch — Thu, 21 Jul 2022 19:11:40 GMT

Its works thanks so much ,and terribly sorry for veryvery late reply
Best Regard
firstch