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
bboy81905's avatar
bboy81905
Frequent Visitor
8 years ago

Thank your response!
But If I group by UpdateTime to 1min, and use this column(MinutesTime), it's working. But sometimes also returned blank! I think this Formula is working in Directquery mode.  It's an issue in Power-BI ?

LatestTurbidity = CALCULATE(MAX(MsgJamhamTest1[Value]), FILTER(MsgJamhamTest1,[Type]="Turbidity"&&[MinutesTime]=MAX([MinutesTime])))

 

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.