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 wou...
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-bd52912a5bd4
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.