Forum Discussion
KPI Visual Goal - Based off previous month's data
I'm having trouble with the Goal piece of the new KPI Visual. The overview of the feature in the video simply created a goal based off the current month's count. This doesn't really make sense. I'...
Ah 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.