Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Inventory days calculation

Need to calculate Inventory and  Debtor days through DAX based on calculations given in below image.

 

Please help!

Need Help

3 Replies

  • Cmcmahan's avatar
    Cmcmahan
    Resident Rockstar
    6 years ago

    So then what's the question? Just how to get the last 12 months of Revenue?  All of the questions?  The formulas are basically given to you in the image.

     

    Is revenue pre-calculated for you, or do you have daily data and need to get the monthly total before averaging those amounts?

     

    The general formula for the past 12 months would be something like this:

    X = CALCULATE( AVERAGE( 'Data'[Monthly Net]), PREVIOUSYEAR( TODAY() ))
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Need your support in creating DAX for X, Y and Z.

       

      I have created following measures for X and Y. However, they are not giving correct values. Is there any problem with these measures?

       

      • Cmcmahan's avatar
        Cmcmahan
        Resident Rockstar
        6 years ago

        It looks generally correct.  At this point it mostly depends on how your data model is set up. Could you share the .pbix file you're using?

         

        If not, an example data set and actual/expected output would be helpful.