YoY change in matrix with year for current year

[Anonymous]

Good evening

I have a matrix with years in the columns. I want to calculate the YoY % change in this matrix only for the elapsed period in the current year ( YTD 2020 vs same period in 2019). Preferably dynamic, so that when the report is updated next year it will compare 2021 with 2020 and so on. The problem is that when I write this measure: it calculates it for every year in my visualisation and this adds way too much columns to my matrix visualisation:

Vorig jaar =

VAR BrutoGewichtVorigJaar =

CALCULATE ( [Brutogewicht]; SAMEPERIODLASTYEAR ( Datumtabel[Date] ) )

RETURN

( [Brutogewicht] - BrutoGewichtVorigJaar ) / [Brutogewicht]

Anyone know how I can only show this YTD YoY Calculation for the current year in the visualisation?

Greetings

[v-shex-msft]

HI @Anonymous,

Please share some dummy data with a similar data structure as your raw data and expected result to help us clarify your scenario and test to coding formula on it.

How to Get Your Question Answered Quickly 

In addition, you can also take a look at the following link to use date function to manually define filter range to calculate.

Time Intelligence "The Hard Way" (TITHW)  
Regards,

Xiaoxin SHeng

[amitchandak]

@Anonymous , Try time intelligence with a date table

YTD QTY = TOTALYTD(Sum('order'[Qty]),'Date'[Date])
LYTD QTY = TOTALYTD(Sum('order'[Qty]),dateadd('Date'[Date],-1,year))
Previous Year = CALCULATE(SUM('order'[Qty]), PREVIOUSYEAR('Date'[Date]))

// forced based on Today
YTD QTY forced= 
var _max = today()
return
calculate(Sum('order'[Qty]),DATESYTD('Date'[Date]),'Date'[Date]<=_max)
//calculate(TOTALYTD(Sum('order'[Qty]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

LYTD QTY forced= 
var _max = date(year(today())-1,month(today()),day(today()))
return
CALCULATE(Sum('order'[Qty]),DATESYTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
//TOTALYTD(Sum('order'[Qty]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)

//Forced based on last avaiable Date 
YTD QTY forced= 
var _max = maxx('order',[Order date])
return
calculate(Sum('order'[Qty]),DATESYTD('Date'[Date]),'Date'[Date]<=_max)
//calculate(TOTALYTD(Sum('order'[Qty]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

LYTD QTY forced= 
var _max1 =maxx('order',[Order date])
var _max = date(year(_max1)-1,month(_max1),day(_max1))
return
CALCULATE(Sum('order'[Qty]),DATESYTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
//TOTALYTD(Sum('order'[Qty]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)

//This year vs last year

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
//year behind measure
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.