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.
Hi All,
I'm new to PowerBI and it is quite a basic query,
so I have date column and I need a conditional column with a specific output for specific months in the date column
example,
For months Jan, Feb, Mar, Apr - 1st intake
may,jun,jul, Aug - 2nd intake
sep, oct, nov, dec - 3rd intake
required output:
Date Intake
12-01-2019 1st intake
13-06-2019 2nd intake
01-11-2019 3rd intake
tried different things but nothing worked, please help me out on this,any help is much appreciated. Thanks
Solved! Go to Solution.
@Anonymous , Try a new column
Switch (True(),
month([Date]) <=4, "1st intake",
month([Date]) <=8, "2nd intake",
month([Date]) <=12, "3rd intake")
@Anonymous , Try a new column
Switch (True(),
month([Date]) <=4, "1st intake",
month([Date]) <=8, "2nd intake",
month([Date]) <=12, "3rd intake")
User | Count |
---|---|
83 | |
76 | |
71 | |
68 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |