Forum Discussion
Compare previous month data to current month
I tried this measure but receive an error when i put it into the target goal position. I changed the Table assignments to match my data (Table1[SERIAL_NUMBER]) for instance. I get the following error:
The Month value that i am working with is just a number representation (1 for January, 2 for February, etc) that I manually add to my spreadsheet. There is no unique key in my data that can identify when i exported it, that is why i manuall fill in. Should this be a full date format?
Thank you for your assistance.
Community ChampionYes you should be using a Date type field to use PARALLELPERIOD. You could continue to use integers, but then you will want to add a year column in addition to the month column to account for what you want to show when it is January. That way is more complicated (lots of IF), so making the Month value be a Date that is the first day of the month is going to be your easiest path.
Hope this helps
David