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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Eivindeiki
Frequent Visitor

Measure for Relative date - Current month +1 month

Hi community, 

I would like a measure that returns the expected sales for next month and next month only without having to include the date field in the table. As of now, I have managed to do so for every month +1 when Year Month is included in the table, but as mentioned I would like a measure where in this case only the 3 102 484,32 is displayed. This is a live connection, so needs to be a measure. 

Eivindeiki_2-1638778275677.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello @Eivindeiki ,

 

Just add the below measure and I hope you will achieve the result:

  • CALCULATE([SalesNextMonth],FORMAT('Table'[YearMonth],"YYYY-MM")=FORMAT(NOW(),"YYYY-MM"))

If I answered your query than mark my post as a solution! Appreciate your Kudos!! !!

For any queries please let me know 😊

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hello @Eivindeiki ,

 

Just add the below measure and I hope you will achieve the result:

  • CALCULATE([SalesNextMonth],FORMAT('Table'[YearMonth],"YYYY-MM")=FORMAT(NOW(),"YYYY-MM"))

If I answered your query than mark my post as a solution! Appreciate your Kudos!! !!

For any queries please let me know 😊

You're an absolute legend! Thanks!

Anonymous
Not applicable

Hello @Eivindeiki ,

Is the below image showing value as expected?

MuskanAgarwal_0-1638778992552.png

I have used the following measures:

  1. MSales = SUM('Table'[Sales])
  2. SalesNextMonth = CALCULATE([MSales],DATEADD('Table'[YearMonth],1,MONTH))

If I answered your query than mark my post as a solution! Appreciate your Kudos!! !!

For any queries please let me know 😊
 
 

Hi @Anonymous., 

Thanks for your reply. 
Unfortunately not, I need a measure that show January only, like below, without using the relative date filter. 

Eivindeiki_0-1638780053674.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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