Forum Discussion
Best Approach to Create a Trimester date label?
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!
Anonymous
Better to do that on a month number column, so:Trimester = SWITCH( TRUE(), 'Date'[Month Number] <= 4, 1, 'Date'[Month Number] <= 8, 2, 3 )
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
5 Replies
- SpartaBI
Community Champion
Anonymous your approach is the right one. What issue are you facing?
- SpartaBI
Anonymous
Better to do that on a month number column, so:Trimester = SWITCH( TRUE(), 'Date'[Month Number] <= 4, 1, 'Date'[Month Number] <= 8, 2, 3 )
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI