Forum Discussion

Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

Measure not display in chart

I have the following two columns are in direct query Date&Time and Time2. I created new measue based on the Date&time column for Time1.  Time1 = FORMAT(CALCULATE(MAX('TIME'[Date&Time])),"HH:MM:SS")...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi Saxon202202 ,

 

Unfortunalty the calculation groups do not work in Direct Query mode so this option is not available for your case, even so if you are interested I can send you a wakltrough.

Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

MFelix , Thanks for your reply again. Yes, I am interested can you please share the information step by step so it will help to understand. 
Question: Direct query will be support to create a new calculated column?