Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Need to calculate Inventory and Debtor days through DAX based on calculations given in below image.
Please help!
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() ))
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |