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 September 15. Request your voucher.
(1) Hi, I created a Date Table and the following DAX column based on My Incident table. Which means if there is ticket created on the particular date, it will return as True or else False
(2) Created a relationship bewteen 'Date table[Date] 1-----* V_Incident[Created on]
(3) Created the following Measure Open Tickets MTD
(4) Apparently, I think the measure is not working, because isn't MTD suppose to the accumulate the value by date untill the end of the month. Is my measure correctly written ?
Reference: https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/
User | Count |
---|---|
15 | |
13 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
19 | |
12 | |
9 | |
7 |