Forum Discussion

GiorgosPap311's avatar
GiorgosPap311
Regular Visitor
2 years ago
Solved

Different Values Depending On Date Hierarchy

I have a very easy (I suppose) question, but it's driving me crazy. We have a table named "Dates" with 1 single column named "Date", let's say this one Dates = CALENDAR("2020-01-01", "2024-01-01")...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi GiorgosPap311 ,

     

    You can refer to below measure.

     

     

    Measure = 
SWITCH(TRUE(),
    ISINSCOPE('Date'[Date]),    4 ,
    ISINSCOPE('Date'[Month]),   3 ,
    ISINSCOPE('Date'[Quarter]), 2 ,
    ISINSCOPE('Date'[Year]),    1
)

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

     

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Hi GiorgosPap311 ,

 

You can refer to below measure.

 

 

Measure = 
SWITCH(TRUE(),
    ISINSCOPE('Date'[Date]),    4 ,
    ISINSCOPE('Date'[Month]),   3 ,
    ISINSCOPE('Date'[Quarter]), 2 ,
    ISINSCOPE('Date'[Year]),    1
)

 

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

 

GiorgosPap311's avatar
GiorgosPap311
Regular Visitor
2 years ago

I had already tried this measure, but only had 1 single column in my Dates table with the Date Hierarchy instead of using 4 different columns. I thought it should be possible only with 1 but it seems like it doesn't work the way I thought.
This works indeed, so thank you!