topic Re: Any alternative for if-else-if statement apart from custom column which can prevent data refresh in DAX Commands and Tips

Any alternative for if-else-if statement apart from custom column which can prevent data refresh

Anonymous — Wed, 09 Feb 2022 20:29:51 GMT

We have loaded huge volume of data(> 1M) from database into PowerBI through ODBC connection.

Need to create a custom column based on if-else-if statement with several and conditions . I have used Custom column option but once I apply changes , the report is again hitting DB for loading data which is taking lot of time.

Is there any other alternative where we can prevent report refreshing data from database.

Thanks !

Re: Any alternative for if-else-if statement apart from custom column which can prevent data refresh

amitchandak — Thu, 10 Feb 2022 04:15:55 GMT

Anonymous , In power query it will. In DAX you can use Switch, bit costly but will work with loaded data

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

Re: Any alternative for if-else-if statement apart from custom column which can prevent data refresh

Anonymous — Thu, 17 Feb 2022 10:02:04 GMT

Hi Anonymous ,

You could try unchecking the Enable load option before creating custom column and enable it after the columns being created.

Best Regards,

Jay

Re: Any alternative for if-else-if statement apart from custom column which can prevent data refresh

Anonymous — Fri, 25 Feb 2022 01:28:53 GMT

Thanks worked as expected