Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I want to calculate the amount of last year if there is no selection in year filter.So in this way it will show 2017 year amount.
But when I will select any other year like 2015 then it should calculate the 2014 year amount.
I am using this DAX expresion but it is not working as i want:
Measure 25 = IF(ISFILTERED(Dates[Year]),
CALCULATE(sum(TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT]),FILTER(Dates,YEAR(Dates[Date])=YEAR(TODAY())-1))
,
CALCULATE(sum(TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT]),FILTER(Dates,YEAR(Dates[Date])=YEAR(TODAY())-1)))
It is working if i dont select any year in filter. But not working when i select the any year in year.
Please guide me to achieve the result.
Thanks,
Narender
Solved! Go to Solution.
Hi @Narender,
Please modify above formula to:
Measure 25 = IF ( ISFILTERED ( Dates[Year] ), CALCULATE ( SUM ( TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT] ), FILTER ( ALL ( TAX_TRANSACTION ), YEAR ( TAX_TRANSACTION[Date] ) = SELECTEDVALUE ( Dates[Year] ) - 1 ) ), CALCULATE ( SUM ( TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT] ), FILTER ( Dates, YEAR ( Dates[Date] ) = YEAR ( TODAY () ) - 1 ) ) )
Best regards,
Yuliana Gu
I resolved it by adding month expression with the last year expression in DAX.
Narender
Hi @Narender,
Please modify above formula to:
Measure 25 = IF ( ISFILTERED ( Dates[Year] ), CALCULATE ( SUM ( TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT] ), FILTER ( ALL ( TAX_TRANSACTION ), YEAR ( TAX_TRANSACTION[Date] ) = SELECTEDVALUE ( Dates[Year] ) - 1 ) ), CALCULATE ( SUM ( TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT] ), FILTER ( Dates, YEAR ( Dates[Date] ) = YEAR ( TODAY () ) - 1 ) ) )
Best regards,
Yuliana Gu
Can you please guide me?
Thanks,
Narender
I resolved it by adding month expression with the last year expression in DAX.
Narender
HI Yuliana,
Thanks for your reply. Its is working now.
I want a little modification in this.if possible please tell me below query dax expression.
Actually i want current month amount of last year when no filter is selected . If user select filter year 2016 then it has to show 2015 year amount of current month.
Thanks,
Narender
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |