Forum Discussion
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...
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
Hi Anonymous,
You can take a look at the following blog about aggregation on duration if it help with your scenairo:
Regards,
Xiaoxin Sheng