Fill down with DirectQuery

[iBot]

Hey Guys,

I'm using DirectQuery. The source of the data looks like this:

Entry No.	Account No
2	600001
2
4	608001
4
9	600003
9
9

I can't use the option "fill down", because of the Direct Query. Is there any way I can create a new Column like this in DAX ?:

Entry No.	Account No	Column I need
2	600001	600001
2		600001
4	608001	608001
4		608001
9	600003	600003
9		600003
9		600003

Thank you for your help!

Best regards

[v-shex-msft]

Hi @iBot,

AFAIK, current power bi has limited the Dax function usage in calculated column/table when you are working with direct query mode.

What type of data source are you working on? You Can try to use SQL query to achieve these fill-down operations if you are using SQL or Oracle which supports the use t-SQL query.

Regards,

Xiaoxin Sheng