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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Saxon202202,

I think this should be related to format function.
AFAIK, format function will force convert the result value to text which not able to be aggregated. (notice: measure formula not able to use on axis field and text type not able to use as aggregated value field)

Regards,

Xiaoxin Sheng

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

    Anonymous ,
    Thanks for your reply.
    Is there alternative option I can achieve the desired result? Please