Forum Discussion

dyingod's avatar
dyingod
Icon for Helper I rankHelper I
8 years ago
Solved

Neither M or DaX formulas recognised

Hello!   I've just spent 2 hours searching for a solution in here & google. I failz. Please help! :)   I have 2 unrelated tables that shouldn't be related anyway.   One of them is simply queryi...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    dyingod,

     

    As mentioned above, you could convert the record into a table and then add to data model. That way, you may use DAX to add a calculated column.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

dyingod,

 

You may combine the two queries in Advanced Editor, and add custom column as follows.

Record.Field(Source2, "RUB")
dyingod's avatar
dyingod
Icon for Helper I rankHelper I
8 years ago

Thanks v-chuncz-msft!

 

Is that the only way? seems a shame to screw up a nicely modelled table with a weird single-value column but yeah if that is what it takes then yes pls! :)

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    dyingod,

     

    As mentioned above, you could convert the record into a table and then add to data model. That way, you may use DAX to add a calculated column.