Forum Discussion
KPI Visual Goal - Based off previous month's data
I did figure out how to do this eventually. You do need to create a new measure, that aggregates the data, and then I used the SAMEPERIODLASTYEAR function, nested in the DATESMTD or DATESYTD function, for Year over Year comparisons.
Hope that makes sense, and helps! It works quite nicely this way, and allows for filtering on different segments.
Helper IIAh okay, that is not quite what I was looking for as I need to compare with the previous month (I have been trying to use the PREVIOUSMONTH fucntion), but the DATESMTD and DATESYTD are both functions that I had not used before and they look like they will be very useful for shorter/longer comparisons. I'll give them a go!
Thanks for the reply!
I found this formula sales_last_month = calculate(sum('Table'[Sales]), PARALLELPERIOD('Table'[Date],-1,MONTH)) here https://community.powerbi.com/t5/Desktop/Compare-previous-and-new-sales/td-p/9872
I haven't tried it yet, but that might work for what you're trying to do.