Forum Discussion

Regular Visitor

4 years ago

Weeks on Hand Calculation

Hello everyone!! I am trying to create an equation for determing Weeks on Hand that mimics the one we currently use in Excel. Here is the current excel formula: =IF(ISERROR(IF(K362<SUM(L348...

Icon for Super User rank

Super User

4 years ago

Staceigh ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

if you are looking for days of inventory

https://www.youtube.com/watch?v=Wr4o5uneFxc

Regular Visitor

4 years ago

I am not quite sure how to attach a PBIX file.

Here is a sample of data upload for PBI:

Here is a sample of current manual file for making production adjusts in Excel:

Here is what the data looks like that is uploaded in the file:

Here is the sample table in PBIX:

Anonymous
Not applicable
4 years ago
Hi Staceigh ,

It makes it easier to give you a solution.

Sample (dummy dataset) data as text, use the table tool in the editing bar.

Expected output from sample data.

Explanation in words of how to get from 1. to 2.

How to provide sample data

How to Get Your Question Answered Quickly

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data
- Staceigh
  Regular Visitor
  4 years ago
  Thank you for the above. I was confused how others could upload a file but I couldnt. I have attached link to google drive that has excel and PBIX files.
  Excel:
  https://drive.google.com/file/d/1Rcj_T42Wid1lyk3f3_sWS0eMC14LVxXx/view?usp=sharing
  
  PBIX:
  https://drive.google.com/file/d/16zTm9_GLF2vGvzgzMV6vAlOFRoP6dh1v/view?usp=sharing
  - Staceigh
    Regular Visitor
    4 years ago
    If you cant access my files above let me know.