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
tex628's avatar
tex628
Community Champion
6 years ago

Hi Liam,

Will you only be selecting single dates?
If not, how is the measure supposed to handle ranges?

Say you select 12th of Feb to 21 of March? 

Br,
J

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