How to visualize previous month

[maxtla2005]

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

[v-nmadadi-msft]

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

[v-nmadadi-msft]

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.

[Praful_Potphode]

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

[Ahmedx · Accepted solution]

pls try