Forum Discussion
Solved
Annual bar graph with first year values as reference
Hello, I am seeking some DAX help to compare annual counts by year with the starting year as a reference for each year. I see the time intelligence functions, but I am not sure how to have them ref...
Hi buitrond
Create a measure using the following DAX Expression to find the First Year Headcount:
First Year = Var _MinDate = CALCULATE( MIN('1.1'[Year_Date]), ALLSELECTED('1.1'[Year_Date]) ) RETURN CALCULATE( [Headount], '1.1'[Year_Date]=_MinDate )Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
VahidDM
Super User
Super UserHi buitrond
Create a measure using the following DAX Expression to find the First Year Headcount:
First Year =
Var _MinDate =
CALCULATE(
MIN('1.1'[Year_Date]),
ALLSELECTED('1.1'[Year_Date])
)
RETURN
CALCULATE(
[Headount],
'1.1'[Year_Date]=_MinDate
)
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
