Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tomascid
Frequent Visitor

Can I "pre-load" measure data?

Hi there - I have a measure that takes a long time to calculate, once the user selects an input parameter. I'd like for PowerBI to "pre-load" or "pre-compute" the measure for all possible input parameters (there's about 300 a user can select from) so the user doesn't have to sit around watching the spinning wheel as PowerBI calculates 'on the fly'. Is that possible?

1 REPLY 1
amitchandak
Super User
Super User

@tomascid , check if part of the calculation can be converted to the calculated column.

 

See if your calculation can use window, offset or index functiosn

Created a YouTube Podcast of all my videos (10+) on Offset, Window, and Index functions. Hope you will like that: https://www.youtube.com/watch?v=GpoITi_tRIw&list=PLPaNVDMhUXGax-j-mEF8ZxL5eV-VcmdvJ&index=5

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.