appear zero in IYA field dax formula for year 2019

[Varpat]

Hi,

I have data ranging from year 2019 till 2022

I have a calculation that returns IYA so lets suppose if august 2022 saw a rise of 3% from August 2021 the IYA would show 103. 

The below formula is working fine but the issue is that year 2019 is also giving IYA numbers, where i would want it to be blank or have zero? 

Rolling YOY month value all(%)-TEST =

 Var

  Deduction = [Sum of all sales_Value]-[Sum Of Value all - YOY]

var Div = [Sum Of Value all - YOY]

var test =

DIVIDE(Deduction,Div)

var iya = 100/100 + test*DIVIDE(1,1)

Return

iya*100.0

[amitchandak]

@Varpat , you can have measures like

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))


last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
Previous year Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth(dateadd('Date'[Date],-11,MONTH)))

or year behind measure

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s