Hello Community,
can someone please tell me what is wrong with first image below?
image 2 works fine
thank you
Zoey
Try
FYQ = SWITCH(TRUE(), 'Date'[Month No] IN {7,8,9}, "Q4")
Proud to be a Super User! |  |
Hi,
FYQ= SWITCH ( Date[Month No], 1, "Q1", 2, "Q1", 3, "Q1", 4, "Q2", 5, "Q2", 6, "Q2", 7, "Q3", 8, "Q3", 9, "Q3", 10, "Q4", 11, "Q4", 12, "Q4", "Unknown" )
OR
FYQ= SWITCH ( TRUE(),
Date[Month No]>=7 && Date[Month No]<=9, "Q3",
Date[Month No]>=1 && Date[Month No]<=3, "Q1",
Date[Month No]>=4 && Date[Month No]<=6, "Q2","Q4" )
Proud to be a Super User! | |
Hi,
FYQ= SWITCH ( Date[Month No], 1, "Q1", 2, "Q1", 3, "Q1", 4, "Q2", 5, "Q2", 6, "Q2", 7, "Q3", 8, "Q3", 9, "Q3", 10, "Q4", 11, "Q4", 12, "Q4", "Unknown" )
OR
FYQ= SWITCH ( TRUE(),
Date[Month No]>=7 && Date[Month No]<=9, "Q3",
Date[Month No]>=1 && Date[Month No]<=3, "Q1",
Date[Month No]>=4 && Date[Month No]<=6, "Q2","Q4" )
Proud to be a Super User! | |
Try
FYQ = SWITCH(TRUE(), 'Date'[Month No] IN {7,8,9}, "Q4")
Proud to be a Super User! | |
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
