Forum Discussion

PBI_Curve's avatar
PBI_Curve
Icon for Helper I rankHelper I
8 years ago
Solved

Filter for all after this month

This might exist already but I've searched for the different phrasings I could think of.   I have 2 sets of values merged together, 1 is forecasts and the other is actuals. I use a basic If formula...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey PBI_Curve

     

    I would recommend using the MONTH function to return the month number of NOW(). Also assuming that your data might have multiple years, you need to also specify that the year number of your data is less than the year number of NOW().

     

    if (MONTH('Value'[date])<=MONTH(now()) && YEAR('Value'[date])<=YEAR(now()), 'show me actual', 'show me forecast')

    Hope this helps,

    Parker

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey PBI_Curve

 

I would recommend using the MONTH function to return the month number of NOW(). Also assuming that your data might have multiple years, you need to also specify that the year number of your data is less than the year number of NOW().

 

if (MONTH('Value'[date])<=MONTH(now()) && YEAR('Value'[date])<=YEAR(now()), 'show me actual', 'show me forecast')

Hope this helps,

Parker

PBI_Curve's avatar
PBI_Curve
Icon for Helper I rankHelper I
8 years ago

Thanks Anonymous, worked a treat!