Best Approach to Create a Trimester date label?

[AlexG16261626]

Hello! I have a standard [Date] column and create trimesters for a graph. What would be the best approach to create a Trimester value/label? I was considering create an entirely new date table, but I think a simple new measure/column would be easier to achieve this.

I was thinking of a calculation along the lines of IF [Date] between January 1 - April 30 then "Trimester 1" ELSEIF date between May 1 - August 31 then "Trimester 2" etc. etc. but was having trouble thinking of the proper construction of this new column. 

Thanks!

[SpartaBI]

@AlexG16261626 your approach is the right one. What issue are you facing?

[AlexG16261626]

I'm trying to think of which functions to use in this calculation.

[SpartaBI · Accepted solution]

@AlexG16261626 
Better to do that on a month number column, so:

Trimester = 
SWITCH(
    TRUE(),
    'Date'[Month Number] <= 4, 1, 
    'Date'[Month Number] <= 8, 2, 
    3
)

      

Showcase Report – Contoso By SpartaBI

[AlexG16261626]

Ahhhh, I'm coming over from Tableau so I wasn't well-versed in SWITCH, thank you!

[SpartaBI]

@AlexG16261626 my pleasure 🙂 and welcome to the best tool 🙂
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543