Forum Discussion
Comparing two previous months with data
Hi,
I would like to compare (calculate change in percentage) two previous months with data. Problem is that there is no data for every month. For example (please look the picture) in line 9 I would like to compare September and December, in line 5 I need to compare October and November and so on. What kind of dax formula I need to do this?
BR,
TuHa
1 Reply
Anonymous , Try a measure like below, make sure you are using date table
new column =
var _max = maxx(allselected(Date), Date[Date]< min(Date[Date]))
return
calculate(Sum(Table[Values]), filter(allselected(Date), eomonth(Date[Date],0) = eomonth(_max,0)))Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
