Solved: How to Find out latest two month records from Colu...

Yashodhan · ‎12-02-2021

I want to make new Column with lastest two month Namely as "New" and other are as "Existing",how to get that ?

negi007 · ‎12-02-2021

@Yashodhan you can create a measure like below

Report Month = IF(MONTH(now()-2) <= Month(sales[date]) && YEAR(now()-1) = YEAR(sales[date]), "New","Others")

Did I answer your question? Mark my post as a solution!
Appreciate your Kudos

Proud to be a Super User!

Follow me on linkedin

negi007 · ‎12-02-2021

@Yashodhan you can create a measure like below

Report Month = IF(MONTH(now()-2) <= Month(sales[date]) && YEAR(now()-1) = YEAR(sales[date]), "New","Others")

Did I answer your question? Mark my post as a solution!
Appreciate your Kudos

Proud to be a Super User!

Follow me on linkedin

Yashodhan · ‎12-02-2021

Thank you for Support ..but from my side it is not giving Solution as I required. it shows all dates as a Existing.

How to Find out latest two month records from Column ?