Storage mode

[Hussein_charif]

Hi, i wanted to know if i have a table in directquery mode, can i add custom columns to it if lets say i cant adjust in my data source (adding the custom column in the source instead)?

[v-priyankata]

Hi @Hussein_charif 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @Hussein_charif 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @Hussein_charif 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Vijay_Chethan]

Hello
You sure can add additional columns using dax but note that not all DAX functions are supported in DirectQuery mode, so you might need to test your specific calculations

if this helps, please mark as solution

[Akash_Varuna · Accepted solution]

Hi@Hussein_charif  In DirectQuery mode, you can't add calculated columns directly to the table. Instead, you can use DAX measures for dynamic calculations. If modifying the source is not an option, consider using Power Query transformations or switching to Import Mode if the dataset size permits. Calculated columns are only available in Import Mode for DirectQuery tables.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance