Forum Discussion

buitrond's avatar
buitrond
Frequent Visitor
2 years ago
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 reference the first year.
The DAX images below are as far as I got (my apologies if this is a beginner question)

DAX Attempts:





Need Help
  • VahidDM's avatar
    VahidDM
    2 years ago

    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 

3 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    2 years ago

    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