Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Showing current and future months

Hi All Probably an easy thing to do but i am trying to have on a line chart the current month as the AXIS plus any month moving forward we do not want to see the previous months and their data. Any...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Has your problem been solved? If not, please show us a sample data.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

 

That is very close but missed the periods 10,11,12 which are April, May, Jun

I tracked the problem to the If statement

Current period 4

FP =10

FY = 2019

EP = 4

EY = 2020

First clause of the if statement would be incorrect as it would default to 2019

I am trying to now resolve the IF statement component

 

The data set has 2 years of data in it 2019, 2020

 

Regards

Skinni

 

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous , 

Is this not the desired interval? 



If not, could you make an excel table in the same way and show me what you're after?

Br,
J