Forum Discussion

iBot's avatar
iBot
Regular Visitor
4 years ago

Fill down with DirectQuery

Hey Guys,

 

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

 

Entry No.Account No
2600001
2 
4608001
4 
9600003
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 NoColumn I need
2600001600001
2 600001
4608001608001
4 608001
9600003600003
9 600003
9 600003

 

Thank you for your help!

 

Best regards

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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