periodOverPeriodLastValue not working

Question & Answer
,
4

Hi @pantelis

  1. Create two calculated field to get Month (as in Jan, Feb, Mar etc) and another one to get Month in integer format from your date field. The calculated field with Month names cane be used on the visual and use the integer one for sorting as an off-visual field

  2. Create two calculated fields for Current Year and Prior Year data. Please refer the article below
    Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

  3. Use the Month Calculated field along with the two calculated fields for current and last year

  4. Do not filter the visual using the date field as the date filtering is taken care in the calculated field.