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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Nash1991
New Member

Measure not working on an old version of power bi desktop

When using the PowerBI Desktop version from January 2021 the following Measure worked:

Vendas 2021 = IF (ANALITICA[ANO]=2021, ANALITICA[CREDITO] - ANALITICA[DEBITO])
 
But now i need to use a downgraded version in order to publish on server, the version that i'm using is from January 2019 and the same measure is not working, due to incorrect syntax.
 
I've been to the docs.microsoft guides in order to see what is wrong with the syntax but i guess its regarding the latest version, any ideas?
 
Thanks in advance, Diogo.
1 ACCEPTED SOLUTION
Nash1991
New Member

If anyone is having the same issue, i discovered that on the older versions of power BI desktop, you got to use ; instead of , that is why i was having a syntax error.

View solution in original post

3 REPLIES 3
Nash1991
New Member

If anyone is having the same issue, i discovered that on the older versions of power BI desktop, you got to use ; instead of , that is why i was having a syntax error.

amitchandak
Super User
Super User

@Nash1991 , to me it seems like a column; not measure in case of measure

 

Vendas 2021 = IF ([ANO]=2021, [CREDITO] - [DEBITO])

 

in case o measure

Vendas 2021 = IF (max(ANALITICA[ANO])=2021, sum(ANALITICA[CREDITO]) - sum(ANALITICA[DEBITO]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak thanks for the help!

unfortunately, its still not working.

i've made a new column and used the first answer you gave me, it still says incorrect syntax. I've appended an image of the error.

 

Thanks, Diogo.Untitled.png

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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