Forum Discussion
Best Approach to Create a Trimester date label?
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
Community ChampionAnonymous your approach is the right one. What issue are you facing?
I'm trying to think of which functions to use in this calculation.
- 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 SpartaBIAhhhh, I'm coming over from Tableau so I wasn't well-versed in SWITCH, thank you!
- SpartaBI
Anonymous 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