Hello guys I need these calculation to work for a card visual to display the value of sum auditfile
i need something like this :
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
My understanding is that you want sum of saldo when for dates after the fiscal year 2018. Try:
CALCULATE(SUM('2 (Auditfile)'[saldo]),FILTER('2 (Auditfile)','2 (Auditfile)'[fiscalYear])>2018))
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI
hey @Shaurya you got it almost i want sum of saldo when in a slicer is 2018 selected i want the sum saldo of 2017, when in the slicer 2019 is selected i want the sum of saldo from 2018, when 2020 is selected i want sum of saldo from 2019 etc etc previeus year function doesnt work for me the way my data is but it think its something like your dax formula
Hi @Krijgerss21 ,
Here I suggest you to create an unrelated Fiscal Year Table for slicer and create a measure to achieve your goal.
Fiscal Year Table:
Fiscal Year = VALUES(Auditfile[fiscalYear])
Measure = VAR _SELECTYEAR = VALUES('Fiscal Year'[fiscalYear]) VAR _PREVIOUSYEAR = SUMMARIZE( ADDCOLUMNS(_SELECTYEAR,"PY",[fiscalYear] - 1),[PY]) RETURN CALCULATE(SUM(Auditfile[saldo]),FILTER(Auditfile,Auditfile[fiscalYear] IN _PREVIOUSYEAR))
Result is as below.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i need something like this but this doesnt work:
if(selectedvalue(auditfile[fiscalyear])>=2019, selectvalue(auditfile[fiscalyear] -1),
so if i select a year in a slicer i want the value of the previous year. the previous year functie does not work for me the way i have the data.
hey @v-rzhou-msft if i use your meassure it returns blanks if i put the new fiscalyear table in it if i use the slicer with auditfile fiscalyear it returns the same value of the year i selected but i want the sum of saldo 2018 if i select 2019 in the slicer iwant the sum of saldo 2019 if i select 2020 enz enz
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.