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.
Good afternoon
I have this DAX formula to segment production by month:
Solved! Go to Solution.
Hi @Syndicate_Admin ,
You can modify your formula like below:
MesF =
SWITCH (
TRUE (),
MAX ( Table1[DATE] ) > DATE ( 2023, 1, 20 )
&& MAX ( Table1[DATE] ) < DATE ( 2023, 2, 21 ), "February2023",
MAX ( Table1[DATE] ) > DATE ( 2023, 2, 20 )
&& MAX ( Table1[DATE] ) < DATE ( 2023, 3, 21 ), "March 2023",
"Out of Range"
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
You can modify your formula like below:
MesF =
SWITCH (
TRUE (),
MAX ( Table1[DATE] ) > DATE ( 2023, 1, 20 )
&& MAX ( Table1[DATE] ) < DATE ( 2023, 2, 21 ), "February2023",
MAX ( Table1[DATE] ) > DATE ( 2023, 2, 20 )
&& MAX ( Table1[DATE] ) < DATE ( 2023, 3, 21 ), "March 2023",
"Out of Range"
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Just create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number. Create a relationship from the Date column of Table1 to the Date column of the Calendar Table.
I already saw the error, after publishing the post. The condition of minor referred to the entire table1 and had to be dated.
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 |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |