Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Month on Hand calculation for Q4 based on Min Inventory

Hello all,

I have to calulate a column MOH calulation by Q4. Below is the screenshot of dummy data in excel attached what I am trying to achieve by using the formula. For viewing tables and and data model please go through my attached pbix file

 

.

 

I have created a pbix which has column on min inventory calculated using power query, I also have measures for Q1 and Q4.

When I try to achive this formula by writing the formula below, 

Meaure = [Min Inventory #]/[Q4] .....(This is my logic but [Min Inventory#] cannot be inserted it gives error

Is it wrong approach to do so?

Please guide me how to proceed to solve this problem. I am also attaching my pbix file for reference.

Thank You.

 

DummyWork.pbix file 

Need Help
Tips and Tricks

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Anonymous 

    I am not sure whether I understood your question correctly, but pleae check the data type of the column MIN Inventory #. I think it is a text type. Please try to change it to number type.

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Jihwan_Kim Yes, I did forget to change column type in my dummy report.

      But I got the solution, I was confusing myself between calculation of Column and Measure. Now, got that confusion correct.

      Thank You.