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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Need Help DAX - Comparing Periods

Im quite new to Power Bi , i hope someone can help me with my topic.

I need help displaying 2 different periods of Data.


I get this error when trying to display my Measure


What do i want to do:

I just want to compare 2 periods of Data - one period is from 2021 - the other is from 2020.


What have i done so far :


1) I have imported tables from a MS SQL Database  - No direct query

The Table with the Data ( especially the clomn with the date ) looks like this.
All Data is in one Table.



2) i have set the displayed filters on the visual - so far so good - data displays right on the visuals




3)  now i want an additional column with data (comparison)  with the 2020 period data
As far as i know "measure´s" are the right thing to accomplish that.

4) My Measure looks like this: 



Measure = calculate(sum('Verkauf lvRechnungsposition'[fBruttoPreisGesamt]),DATEADD('Verkauf lvRechnungsverwaltung'[dErstellt],-3,YEAR))



Once i drop the measure into my visual i get the error above


I can not identify the error here, i dont know what i have done wrong.

I hope someone can give me a hint on this.
Thank you !


Super User
Super User

@Mitsch , You need to use date table for that


Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :



Time Intelligence, Part of learn Power BI
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date:

@amitchandak  Thank you i will consider this

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.