Forum Discussion

bboy81905's avatar
bboy81905
Frequent Visitor
8 years ago

Filter MAX date is not working in Directquery mode

Hi everyone :  My report needs to present the latest value, so I try below formula : LatestTurbidity = CALCULATE(MAX(MsgJamhamTest1[Value]), FILTER(MsgJamhamTest1,[Type]="Turbidity"&&[UpdateTime]=M...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI bboy81905,

 

I think it may related refresh interval, maybe you can try to increase your filter range to get more records.(direct query live connect but I think it still has update interval)

 

Regards,

Xiaoxin Sheng

bboy81905's avatar
bboy81905
Frequent Visitor
8 years ago

Thank your response.  Now my solution is using SQL languages to select latest data.

I think Power-BI is not efficient in using DAX "CALCULATE" if your database is huge, not to mention Directquerry mode.