Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PARALLELPERIOD Filter Problem

Hello,   I have a table which shows a value for the current month and a value for the previous month.  Take for example here:   Month           Input Plant.Actual June 2017     500 May 2017    ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    It works just fine for me.  Please see the image (notice that i have select Current month as yes in the the filter pane).  These are the measures that i used

     

    Current month = SUM(Data[Actual])
    Previous month = CALCULATE([Current month],PREVIOUSMONTH('calendar'[Date]))

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the solution Ashish.  Upon further inspection I noticed you have a select "Current Month" as a yes in your filters.  Further, I noticed that your PREVIOUSMONTH function used just the 'calendar'[DATE] as the field and whereas mine was using 'calendar'[DATE].[Date].  Or in other words, I was using Power BI's built in date heirarchy in my formula, while my "Current Month" filter was for just the column in my data source.  They weren't speaking to each other and I wasn't getting the results back.  Once I fixed this, I was able to get the results that I needed with your simplified formula.  :smileyhappy:

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

You are welcone.