Forum Discussion

rsbin's avatar
rsbin
Community Champion
3 years ago
Solved

Virtual Table within a Calculated Column

Good Afternoon, Looking for some assistance with a Calculated Column dealing with Inventory. Have a Table of On Hand Inventory. Facility Item Pre-AdjustmentDate OnHandPreAdjustment ...
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    Something like this might work...

    Adjustment =
    var _vTable =
    FILTER(
        SUMMARIZE(
            txTable,
            txTable[Item],
            txTable[Facility],
            txTable[Date],
            "sumQTY", SUM(txTable[Qty.])
        ),
        txTable[Item] = onHandTable[Item] && txTable[Facility] = onHandTable[Facility] && txTable[Date] = onHandTable[Adjustment Date]
    )
    Return
    SUMX(
        _vTable,
        [sumQTY]
    )
rsbin's avatar
rsbin
Community Champion
3 years ago

jgeddes ,

Thanks much for the prompt reply.

At first glance, appears to be what I am looking for.  Will give it a shot later today and let you know how I make out.

Thanks again!

Regards,

rsbin's avatar
rsbin
Community Champion
3 years ago

jgeddes ,

Just wanted to let you know that I got it to work as expected.  Thanks again for the assist.

Regards,