Forum Discussion

fyong's avatar
fyong
Frequent Visitor
3 years ago
Solved

How to count balance for replenish ?

 Hi Team ,    Can anyone share with me the dax function to get the outcome at "want this outcome" column? I have created many to many relationship , matrix table .
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi fyong 

    You can refer to the following measure

     

    Balance_ =
[PO QTY]
    - SUMX (
        FILTER (
            ALLSELECTED ( 'Demand Table' ),
            [Item ]
                IN VALUES ( 'Demand Table'[Item ] )
                    && [Ordered_Date] <= SELECTEDVALUE ( 'Demand Table'[Ordered_Date] )
        ),
        [Demand QTY]
    )

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
3 years ago

Hey fyong ,

 

I'm. not able to create any DAX without knowing what to do, only staring at the outcome column will create a solution that most likely is based wrong assumptions. You mentioned that you created many-to-many relationships between tables, is my understanding correct? Without knowing the exact relationships it's also not possible to create a DAX measure.

Consider creating a pbix that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive, google drive, or dropbox. If you are using Excel to create the sample data instead of the manual input method, then share the xlsx sheet as well. Do not forget to explain the expected result based on the data you provided.

 

Regards,

Tom