The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
wondering if someone can help with this use case.
I have a calendar table which has dates from start of 2021 up to end of 2022 - I've got a column which works out quarter number.
What I am trying to do is a calc which works out the end date of each quarter - then I want to do a column calc which displays any dates between current date (today) and end of the current quarter as a 1 and the rest of the dates as a zero.
Any help greatly appreciated on this one.
Thanks
User | Count |
---|---|
13 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |