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
noah44's avatar
noah44
Helper I
3 years ago

Hi v-yalanwu-msft,

 

Thank you for your answer!

I understand that the above formula does not Work in Direct Query mode.

So the two ways shown in your post won't work either because of CALCULATE() not being available in DQ-Mode.

 

Is there no alternative way of reaching the same result, within the DQ-Mode restrictions?

Regards
Noah

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