Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Community,
can someone please tell me what is wrong with first image below?
image 2 works fine
thank you
Zoey
Solved! Go to Solution.
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" )
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" )
Thank you this is great!
Zoey
Try
FYQ = SWITCH(TRUE(), 'Date'[Month No] IN {7,8,9}, "Q4")
Proud to be a Super User! | |
Perfect!! thank you
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
87 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |