Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Previous month calculation

Hi,   I'm looking to add a measure to a filter on to my table.    I need to get the data to display the previous month and up to 10th of the next.   E.g. if my report runs on the 1st April I ne...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi tex628 ,

 

Thanks for your reply.

 

My data comes in in monthly snapshots which I filter on the slicer so E.G. 202002, 202003,202004 etc.

 

For this specific view I need the data's date to be a month and 10 days in arrreas.

 

I was thinking of using the slicer to select all and then having a running measure filter to say a month and 10 days previous?

 

I hope that makes sense,

 

Thanks

 

Liam

tex628's avatar
tex628
Community Champion
6 years ago

Alright, 

So you currently filter by selecting snapshots in a slicer.

If you select '202002' in you slicer, exactly what range of dates do you want this measure to calculate with?

Br,
J

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI tex628,

     

    I would basically  want 202002 and then the first 10 days from 202003, but rolling.

     

    Thanks

     

    Liam