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.
Looking to create Fiscal Year YTD the result that i get is not correct
Hi @Redman22 ,
Please confirm the correct syntax for sumx().
SUMX function (DAX) - DAX | Microsoft Learn
Before you use a function in DAX, you should always check what it does and what it requires as arguments. Here's what you should consult: DATESYTD – DAX Guide. Programming is strict. You can't throw anything at a function and expect it to work. It doesn't work like that.
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
7 |