Forum Discussion
Defining a variable in a custom column?
Hello, I have data that I am appending into one table - one table has a submission column (number) the other table does not so these rows are importing as 'null.' I would like to change all of t...
- If you work on "Queries" than it's power query and so M language, but you are writing Dax code. So that function should be a calculated column in the editor rather than query.
I'm honestly not sure what the difference is between Power Query vs Dax - I have been attempting to manipulate the data in the Queries instead of creating Measures.
Here is an example of what the data looks like - I am appending the LE table to the RO table and the RO table does not have a submission number because I do not need to see past versions, just the current version.
| LE/RO | Value | Submission |
| RO | 100 | null |
| RO | -50 | null |
| LE | -30 | 4 |
| LE | -20 | 3 |
| LE | -10 | 2 |
I only want the RO dataset to be combined with the most recent submission.
If you work on "Queries" than it's power query and so M language, but you are writing Dax code. So that function should be a calculated column in the editor rather than query.
Anonymous Yes, sorry if I was unclear, but I was using that formula in a Calculated Column within that table/query.
You're saying that if I use that data in the editor and create a new measure that will work?