Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
105 | |
88 | |
74 | |
67 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |