The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
When using the PowerBI Desktop version from January 2021 the following Measure worked:
Solved! Go to Solution.
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.
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.
@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]))
@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.
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |