Forum Discussion

naoyixue1's avatar
naoyixue1
Icon for Post Patron rankPost Patron
5 years ago
Solved

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!

 

 

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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.

4 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    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.

    • naoyixue1's avatar
      naoyixue1
      Icon for Post Patron rankPost Patron
      5 years ago

      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!