Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@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
)
@Anonymous your approach is the right one. What issue are you facing?
I'm trying to think of which functions to use in this calculation.
@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
)
Ahhhh, I'm coming over from Tableau so I wasn't well-versed in SWITCH, thank you!
@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
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
102 | |
55 | |
28 | |
18 | |
13 |