Coding multiple complex calculations on import using Code instead of multiple backend tables

[Smnhrt]

Hi All,

Was helping could get some help on this subject.

I have a situation where I have created a dashboard for a client, where client needs to upload a single text file to update dashboard.

However, this text file feeds a backend of 30 tables, running different calculations (including rankings etc etc).

The client's concern is this will be  too complex maze for down-the-line clients, making this dashboard not scalable.

Is there simple way of doing complex calculations (possibly creating temp tables etc) UPON importing text files in PowerBI and therefore only needing tables that will directly feed the visuals.

This method would ideally be a code (such as SQL server, Python, R or even Dax), as long we as we have one page of code for easier maintenance

Screenshot showing multiple backend tables with coding within multiple tables:

Simon 

[v-chenwuz-msft]

Hi @Smnhrt ,

It is not necessary to create each table indeed, you can create a measure to calculate the rank or some other calculations when you want to display the data in table visual or some other visuals. This will create a temporary table depend on context during the calculation rather than show some tables in Data view.

Measures in Power BI Desktop - Power BI | Microsoft Docs

However, there is no more method to create a table either temporary tables and some similar function, calculatetable(), filter(),is used to create tables.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.