Inventory turnover SQL query and DAX (confused)

[Tuvdata]

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. 

[v-juanli-msft · Accepted solution]

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
Maggie

Community 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.

[Tuvdata]

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
Maggie

Community 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.

[Greg_Deckler]

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