Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

hardcode last month date

Hi All, I currently i have this measure and i would like it to always filter last month. How would i do that?    Calculate (measure, Date(yearmonth)=202105)    Since this month is june i would l...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI, 

 

thanks alot for the quick reply!! 

 

I have tried your measure but for the future months, it still calculates a moving "previous month". 

What I would like is that in Jun, jul , aug ,sept.... it should only filter by MAY. i.e all the months going forward I would like to show a static MAY. The background is that I am calculating an allocation key based on trends for the past 6 months. And I would like to use a static allocation key (MAY) for all the months going forward for the rest of the year. 

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Did you try my measure?

 

Best Regards,

Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi dedmon, 

     

    thanks alot for your suggestion but your measure results in a "moving month" as well. I need the month to be static for the rest of the year. meaning if its july now then we should filter june  for the rest of the year. but when we move into aug, we should filter july data and use that for the rest of the year. like a drag on formula.