Annual bar graph with first year values as reference

[buitrond]

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 reference the first year.
The DAX images below are as far as I got (my apologies if this is a beginner question)

DAX Attempts:

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[VahidDM · Accepted solution]

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!! 

LinkedIn | Twitter | Blog | YouTube 

[buitrond]

YES!!!
Exactly what I needed.
Thank you @VahidDM