Forum Discussion
DAX help calculated column boolean mask emulation
Hi, Tlessa
Where possible, try pre-aggregating data in the Aquisições and Baixas_Payments tables. This can mean creating intermediate tables or measures that contain aggregate values that can be referenced by calculated columns. This reduces the amount of data that needs to be processed in the calculated column itself. If there are parts of your calculations that don't change often, such as historical data, consider materializing those calculations as static tables with Power Query. This way, you won't have to recalculate the values every time.
If there are parts of your calculations that don't change often, such as historical data, consider materializing those calculations as static tables with Power Query. This way, you won't have to recalculate the values every time. You can check the following link:
DAX query view in Power BI Desktop - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yeah i have been trying to pre aggregate them and toss the load to PQ however, some of the values in the dax query refference other calculated columns so they dont exist within PQ on load. Just after the data is loaded the columns are calculated in dax... because then and only them the required columns exist.
Still trying to figure this one out =/