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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I need to calculate the YTD for the previous year and have come up with the formula listed below
CALCULATE(SUM(financials[ Sales]), FILTER(financials,financials[Year]=2014 && DATESYTD(financials[Date].[Date])))
and have tried
CALCULATE(SUM(financials[ Sales]), FILTER(financials,financials[Year]= "2014" && DATESYTD(financials[Date].[Date])))
Case
Case 1 :In the 1st case it is throwing an error : A table of multiple values have been supplied where as a single value was expected
Case 2 : It doesn't support comparing values of type integer with values of type text. Try using FORMAT function.
Please help me in re correcting on the measure part
Always use date table and not .[date].
Refer to this video/blog for correction:
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
I did use the Date Table, but yet, it doesn't provide me with the solution
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
7 | |
7 | |
4 | |
3 |