Forum Discussion

sayanika's avatar
sayanika
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Creating power BI report with customized aggregate measurement

Hi,

Could you please help me to understand the possible option to write custom code while creating power BI report using custom aggregate measurement.

One of the customer is trying to create custom aggregate measurement in F&O for using in power BI report. He is now trying to create a method (which he wants to access in power BI report) and implement few custom logic /call few custom class in it and return a calculated value (e.g. sales totals value for a specific sales order). He tried using computed column of a view to achieve this, but that is becoming complicated as he needs to use sub query for writing the entire logic.

So apart from using a computed column of a view, is there any other option where we can write custom code and return a calculated value and in turn capture it in the aggregate measurement ?

 

Thanks

No RepliesBe the first to reply