Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax calculation

Hello guys I need these  calculation to work for a card visual to display the value of sum auditfile CALCULATE(SUM('2 (Auditfile)'[saldo]), IF(VALUES('2 (Auditfile)'[fiscalYear])>2018,[fisc...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

i need something like this :
if(selectedvalue(auditfile[fiscalyear]=2019,selectvalue(auditfile[fiscalyear]-1),
calculate(sum(auditfile[saldo])

but this doesnt work, so i need a measure that if i select a fiscal year in slicer it gives me the sum of saldo of the previous year but i cant use the previous year functie because the way i have the data