Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
JimT99
Helper I
Helper I

Year-to-date calculation with criteria yielding wrong result

Basically I'm trying to calculate the sum of acceptedwt for the year to date where sys = 1

Sys1g =
CALCULATE(1000*SUM(Statistics[acceptedwt]), Statistics[sys] =1 && YEAR(Statistics[STA_PeriodEnd]=Year(today()))
 
I think the filtering isn't working the way I want it to work.
Any help would be appreciated.
1 REPLY 1
Greg_Deckler
Super User
Super User

@JimT99 Try this: Better Year to Date Total - Microsoft Fabric Community



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.