Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Its works thanks so much ,and terribly sorry for veryvery late reply
Best Regard
firstch
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
hi@ Raymundo2910 will PREVIOUS YEAR WORK? cause i didnt have date dimension
Best Regard
firstch
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
28 | |
23 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |