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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
naoyixue1
Post Patron
Post Patron

Last Month Calculation based on not fiscal Month

Hey there,

 

Try to calculate the previous month production. Although I already add one column for 'YearandMonth' (year*100+month) in whole number format, but it still doesn't work. I think my logic is correct, but it always shows zero...just no idea what's wrong with that dax? Would you help to check? Thanks!

 

naoyixue1_0-1621182168355.png

 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @naoyixue1 

Try this,

Last Month Production=Calculate([Produced Qty],Filter(ALL('Time Lookup'),'Time Lookup'[YearandMonth]=Selectedvalue('Time Lookup'[YearandMonth])-1))

If the problem is still not solved, it indicates that your formula seems to be OK, so maybe there's something wrong with your measure.

Can you provide more details about your data model and table structure, or PBI sample file after removing sensitive information? It will help to work out the solution quickly.

 

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-xiaotang
Community Support
Community Support

Hi @naoyixue1 

Try this,

Last Month Production=Calculate([Produced Qty],Filter(ALL('Time Lookup'),'Time Lookup'[YearandMonth]=Selectedvalue('Time Lookup'[YearandMonth])-1))

If the problem is still not solved, it indicates that your formula seems to be OK, so maybe there's something wrong with your measure.

Can you provide more details about your data model and table structure, or PBI sample file after removing sensitive information? It will help to work out the solution quickly.

 

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

@v-xiaotang It works. Thanks a lot! 

 

Yi

Ashish_Mathur
Super User
Super User

Hi,

If you have a Calendar set up with a proper relationship to your base data table and your slicer is from the Calendar table, then this simple measure should work

=calculate([product qty],previousmonth(calendar[date]))

Ensure that you select a Year/Month in the slicer.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hey Ashish Mathur,

 

Thanks. But I'm now dealing with the non standard calendar...That's why I cannot use that previousmonth dax to calculate. Thanks!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.