Custom Column error with Calculate Filter DAX

[Anonymous]

I had perfectly working custom column, which worked fine when created in "Data" view of Power BI. No errors.

When I deleted column and tried to create again in "Edit Query" view (Edit Query->Add Column->Custom Column->Custom Column Formula), I'm getting error. Why exactly same DAX formula is not working?

MachineId =

CALCULATE (

FIRSTNONBLANK ( Machine[MachineId], 1 ),

FILTER ( ALL ( Machine ), Machine[MaintenanceId] = MachineSelectedForUnion[Code] )

)

[cosminc]

Hi,

check the relationship, it was posible to had breaken when you deleted the column.

Hope it helps,

Cosmin

[MartynRamsden · Accepted solution]

Hi @Anonymous 

You can't use DAX within Power Query - Power Query uses the M language.

Best regards,

Martyn.