Forum Discussion

1001's avatar
1001
Icon for Resolver II rankResolver II
3 years ago

Help creating a table from other tables.

Hi All, every DAX example I find on the web is not working. I have three tables: tbl_Date (col: Date) tbl_Delivered (col: Del qty) tbl_Forecast (col: Fcst qty)   Step 1 - bring these columns t...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Try this measure

ABS var_new = SUMX(VALUES(Data[Product]),[ABS var])

Replace Data[Product] with the table and column name which you have dragged to the row labels of the matrix.

1001's avatar
1001
Icon for Resolver II rankResolver II
3 years ago

Thanks Ashish,  but the issue with this formula is the Var number is a Measure, not a calculated column which SUMX needs to perform. And the Qty Del and Qty Fcst columns live in two separate tables. This is the mess I've run into. Thx.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    I cannot help witthout a file.  Simple.

    • 1001's avatar
      1001
      Icon for Resolver II rankResolver II
      3 years ago

      Hi Ashish, am creating a duplicate dummy PBI file. Will upload it tomorrow. Many thanks for your help.