fixed year

2 Topics

Measuring change in values on specific dates
Hi all, I'm trying to use 'VAR' to do measure the change between 2 numbers on specific dates. Basically, (old-new)/old - between 2 specific points of time that won't move, or change. They are fixed dates and fixed figures. This data is static. (the end result showing a -/+ % change). Table is built like this: Sector Name Value Date A 1 2019 B 2 2019 C 3 2019 D 4 2019 A 5 2050 B 6 2050 C 7 2050 D 8 2050 I want to know the change from VALUE between 2019 and 2020, for each SECTOR (will use a filter selection). Code I've attempted: Value % difference from 2019 b = VAR base = CALCULATE( SUM('Employment by Industry'[Value]), 'Employment by Industry'[Year] IN { "2019" }) Var future = CALCULATE( SUM('Employment by Industry'[Value]), 'Employment by Industry'[Year] IN { "2050" }) Var subtraction = CALCULATE((Var base - var future) Var result = DIVIDE(var subtraction, var base) RETURN IF ( not isblank(var result) Can someone please advise? thank you! 🙂
Solved
Jelbeanie
1 year ago Place DAX Commands and Tips
625Views
0likes
3Comments
Dynamic Year Measure
Jolly Day, I currently have my visual set to just give me year 2021. I am wanting it to automatically update go two years back so I need it set to year 2022 when we begin year 2024. Is there a way to accomplish this? I created a year column that just parsed the year from my date so we also have the full date to work with. Any help with this would be greatly appreciated! Thanks in advance, Idon'tquitegotthepowerBI
Solved
Anonymous
3 years ago Place DAX Commands and Tips
3.3KViews
0likes
3Comments