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]
    )
jgeddes's avatar
jgeddes
Super User
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,