Forum Discussion
Inventory turnover SQL query and DAX (confused)
Hello everyone.
I am having an issue on "Inventory turnover" "Average inventory" dashboards. We are have both direct query and import mode available. I am not sure what your SQL source table looks like and what codes do you write on DAX to see inventory turnover?
I did research a lot about inventory turnover on PowerBI from internet. But i couldnt find one with inventory SQL query.
Please feel free to ask anything if my question is not clear enough for you.
Any suggestion, example would be deeply appreciated.
Thank you
Edit: We use SAP for our sales and WH record.
Edit: Sorry. i dont have any example file or image because I have almost nothing done regarding to inventory turnover.
Hi Tuvdata
First, connect to SAP with Power BI Desktop, select the correct database and table from SAP,
https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector
Second, create relationships among tables in Power BI,
https://docs.microsoft.com/en-us/power-bi/desktop-relationships-understand
Next, create measures/calculated columns in Power BI,
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns
For your scenario, please refer to the following article:
https://www.sqlbi.com/articles/inventory-in-power-pivot-and-dax-snapshot-vs-dynamic-calculation/
Finally, create visuals on reports pages to display your results.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-report-visualizations
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- Greg_Deckler
Community Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
v-juanli-msftCommunity Support
Hi Tuvdata
First, connect to SAP with Power BI Desktop, select the correct database and table from SAP,
https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector
Second, create relationships among tables in Power BI,
https://docs.microsoft.com/en-us/power-bi/desktop-relationships-understand
Next, create measures/calculated columns in Power BI,
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns
For your scenario, please refer to the following article:
https://www.sqlbi.com/articles/inventory-in-power-pivot-and-dax-snapshot-vs-dynamic-calculation/
Finally, create visuals on reports pages to display your results.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-report-visualizations
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you for the response.
The thing is we dont have that version of SAP. We only purchad SAP Business one. this version lacks some features. So we are connecting to Power Bi by SQL. Writing our custom SQL query to connect to Power Bi. so thats why i just wanted to see how an official form of WH report SQL table looks like.
- v-juanli-msft
Hi Tuvdata
"we are connecting to Power Bi by SQL. Writing our custom SQL query to connect to Power Bi",
What is the purpose of the SQL used when connecting from SAP to Power BI?
Filtering some data? add some columns?
Create a view?
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
