Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Average calculation issue with Direct Query mode

Hello,   I'm currently working on Sprinklr data exploitation in PowerBI by using the dedicated Spark connector (DirectQuery mode). All is going fine except for duration average calculation.   I'm...
Need Help
changqing's avatar
changqing
Resolver II
4 years ago

Hi Anonymous ,

 

Would you please share the formula of TIME MEASURE? 

Is there row-level security?

And please check the modeling-limitations

 

Best Regards,
changqing

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello changqing, thanks a lot for helping 🙂

 

The formula was basically the one proposed by amitchandak but the average calculation on the first line was returning 0 in all cases.

 

There's no row-level security.

 

I took a look at the modeling limitations and I don't really see something that could avoid me to calculate the average.

 

That's very frustrating to don't be able to see the raw data behind...

 

Best regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous,

    You can take a look at the following blog about aggregation on duration if it help with your scenairo:

    Aggregating Duration Tim 

    Regards,

    Xiaoxin Sheng