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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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