Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I am creating a report from Dynamics 365 to show data for cases. I want to see how long each record has been open for, fortunately the Dynamics 365 source (incidents table) already provides a function called CalculateTotalTimeIncident.
But I can't figure out how to show the data row by row in Query Editor. How can I extract and consume the data from the formula column?
Solved! Go to Solution.
HI @procurtstinate,
I'd like to suggest you use function methods to invoke store function:
Regards,
Xiaoxin Sheng
HI @procurtstinate,
I'd like to suggest you use function methods to invoke store function:
Regards,
Xiaoxin Sheng
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 112 | |
| 108 | |
| 39 | |
| 34 | |
| 27 |