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
Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

MFelix , Thanks for your reply. Yes, please help me and explain the steps and share the PBI file. 
just let you know the source of data is direct query and came SQL.
I am trying to change the datatype by using convert function with data type "Date and Time" but still same result.

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?