Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX script to M language

Hi. I would like to know if this calculated column in DAX is possible to be achieved in Advanced Editor (M language):   calculatedColumn = CALCULATE ( VALUES ( 'AuxTable'[value] ), FILTER ( 'A...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    I think the custom column would look something like this:

     

    Table.SelectRows(AuxTable, (row) => row[start_date] <= [date] and row[end_date] >= [date])[value]{0}

    In the above, row is just a variable name. I could have used x or r or _ or whatever.

     

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

from a first look you should be able to do that in M.

There you might have to do a join (Merge queries).

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis