Inventory days calculation

[Anonymous]

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

Please help!

[Cmcmahan]

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]

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]

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.