Forum Discussion

noah44's avatar
noah44
Helper I
3 years ago

Alternative for calculated column in Direct Query

Hi, is there a way to create a calculated column with Direct Query that gives me the same output as this one?   Max Date = CALCULATE( MAX( Table1[DateColumn] ), ALLEXCEPT( Table1, Table1[Us...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, noah44 ;

Because in DQ can't create column,so you could create a measure by dax


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

noah44's avatar
noah44
Helper I
3 years ago

v-yalanwu-msft 

 

Ok, I think the thing I am trying to achievie is not possible then.
Because even if I do it as a measure, I need to use this measure in another column and that isn't possible either because of DQ restrictions.

 

Thank you anyways

 

Best regards

Noah