Formula to show customers who have previously bought products, but haven’t bought any in the last 3 months

[Kats107]

Hi, I'm trying to work out a formula in Power BI to show customers who have previously bought products, but haven’t bought any in the last 3 months. I can't get it quite right. Any ideas please?

 

[bbotzong]

Have you tried adding a column using the Data Model? Make sure your table/source has been added to the data model. On the Power Pivot tab, click MANAGE in the Data Model group. Assume the last purchase date is in a column named LastPurch, select a blank cell under Add Column and enter this:

=if(now()-Table1[LastPurch]<=90,"Yes","No")

This method returned the correct value of Yes for purchase within the last 90 days.

 

[Kats107]

Have you tried adding a column using the Data Model? Make sure your table/source has been added to the data model. On the Power Pivot tab, click MANAGE in the Data Model group. Assume the last purchase date is in a column named LastPurch, select a blank cell under Add Column and enter this:

=if(now()-Table1[LastPurch]<=90,"Yes","No")

This method returned the correct value of Yes for purchase within the last 90 days.

Hi, thanks for your reply. I'm trying to do this in Power BI so there isn't a Power Pivot tab?