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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 35 | |
| 31 | |
| 20 | |
| 13 | |
| 10 |