Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I have the following Episodes table:
Epi_ID Month
22 01/01/2019
22 02/01/2019
22 03/01/2019
22 04/01/2019
22 05/01/2019
23 03/01/2020
24 06/01/2020
I need to create a calculated column wish will place "1" value for each beginning / end of the Quarter in [Month] column, otherwise should be "0" value, as below:
Epi_ID Month NewColumn
22 01/01/2019 1
22 02/01/2019 0
22 03/01/2019 1
22 04/01/2019 0
22 05/01/2019 0
23 03/01/2020 1
24 06/01/2020 1
why no 1 for April?
User | Count |
---|---|
11 | |
4 | |
4 | |
3 | |
3 |