Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
mmilicic
Frequent Visitor

Get value of next month

Hello,

 

I am trying to get value of next month.

I have slicer applied on current month, but in my table I would like to get value of next month.

 

mmilicic_0-1653559616448.png

 

@amitchandak  - do you have any advice?

 

All the best,

1 ACCEPTED SOLUTION
HenriqueReis
Resolver I
Resolver I

Hi, how are you?

 

You should create a measure with this formula:

HenriqueReis_0-1653562312407.png

Then, put the columns on a table visual and you gonna have this:

HenriqueReis_1-1653562384470.png

Notice I created the slicer visual too.

So, filter the visual according your preference and remove the column "VALUE" if you want:

HenriqueReis_2-1653562465202.png

 

I hope it helps you.

 

REGARDS!

View solution in original post

2 REPLIES 2
mmilicic
Frequent Visitor

Thanks @HenriqueReis , it works!

HenriqueReis
Resolver I
Resolver I

Hi, how are you?

 

You should create a measure with this formula:

HenriqueReis_0-1653562312407.png

Then, put the columns on a table visual and you gonna have this:

HenriqueReis_1-1653562384470.png

Notice I created the slicer visual too.

So, filter the visual according your preference and remove the column "VALUE" if you want:

HenriqueReis_2-1653562465202.png

 

I hope it helps you.

 

REGARDS!

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.