Forum Discussion

pdijkvan's avatar
pdijkvan
New Member
8 years ago

Filter previous period

Can someone help me with the following problem:

 

I have defined the year as 2017/01, 2017/02 etc. Now I want to apply a automatically filter that gives the data of the previous months. So in 2017/12 I want the resultas of the previous 11 months.

 

Suggestions?

 

Thank you.

 

Peter

 

Need Help

3 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi pdijkvan,

    Please refer to this similar thread. It's hard to reproduce your scenario as WolfBiber and smpa01 said. So please create sample table if you still haven't resolved your problem based on the thread.

    Thanks,

    Angelia