Measure for Relative date - Current month +1 month

[Eivindeiki]

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. 

[MuskanAgarwal · Accepted solution]

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 😊

[Eivindeiki]

You're an absolute legend! Thanks!

[MuskanAgarwal]

Hello @Eivindeiki ,

Is the below image showing value as expected?

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 😊

[Eivindeiki]

Hi @MuskanAgarwal., 

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