Forum Discussion

maxtla2005's avatar
maxtla2005
New Member
10 months ago
Solved

How to visualize previous month

Hello, 

I have as month from 1-12. And I need to visualize the ACT, FC and Budget of the actual month (as slicer) and the previous month too (month -1). But I cannot figure that...

 

Can you please help? 

I have this formula but is not working:

FC_FY26_pm = CALCULATE(SUM(Sheet1[FC 2026]), Sheet1[Month]=SELECTEDVALUE(Sheet1[FC 2026])-1)
Any help will be appreciated!
Monica
Show and Tell

4 Replies

  • Praful_Potphode's avatar
    Praful_Potphode
    Super User
    10 months ago

    Hi maxtla2005 

     

    you can create a field parameter to toggle between actuals,budget,forecast and previous month(as slicer).

    please refer below pbix for reference.

    4855471.pbix 

     

    Please give Kudos or mark it solution once confirmed.

     

    Thanks and Regards,

    Praful

     

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    10 months ago

    Hi maxtla2005 

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


    Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    10 months ago

    Hi maxtla2005 

    May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


    Thank you