Forum Discussion

I_Like_Pi's avatar
I_Like_Pi
Icon for Resolver II rankResolver II
10 years ago
Solved

Creating a measure from value on multiple related Tables (NEWB)

I have 1 flat transaction data source that I have created 2 tables from. 1 is pretty much a straight dump of the data, and the other is built using the summarize command to get the Stats of the Store...
Need Help
  • jahida's avatar
    jahida
    10 years ago

    I definitely don't think you need to do anything in Edit Queries (no need for a merge), but I do agree that making this as a calculated column in the Transaction table is your best bet. Note you'll need to add a RELATED() around any reference to a column in the other table.

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
10 years ago

I would suggest you make a calculated column based on my interpretation of your post.

 

In the Data screen, the Edit Queries icon that opens the Query Editor - there one would Merge Queries to join your 2 tables, and then one would Add Column where you enter your DAX statement in the column header field it provides.

jahida's avatar
jahida
Icon for Impactful Individual rankImpactful Individual
10 years ago

I definitely don't think you need to do anything in Edit Queries (no need for a merge), but I do agree that making this as a calculated column in the Transaction table is your best bet. Note you'll need to add a RELATED() around any reference to a column in the other table.

  • I_Like_Pi's avatar
    I_Like_Pi
    Icon for Resolver II rankResolver II
    10 years ago

    KABOOM

    You are a rockstar jahida!!

    Thanks,

    I'm such a NEWB

     

    I could not figure out why it would not accept a column from another table in the calc.

    • jahida's avatar
      jahida
      Icon for Impactful Individual rankImpactful Individual
      10 years ago

      Haha thanks, yeah the related function is a bit to get your head around (doesn't feel like it should be necessary but is).