Forum Discussion

marie_joy's avatar
marie_joy
Frequent Visitor
2 years ago

Optimizing Power BI DAX for Historical Receivables Calculations

Hi everyone, I'm working on a Power BI dashboard to analyze historical receivables data from a Navision database. I've created a calendar table with fiscal years starting on July 1st and ending on J...
marie_joy's avatar
marie_joy
Frequent Visitor
2 years ago

Hi some_bih 

Thanks for your reply, in fact it is the DAX queries that takes long: between 30s and 50s. Particularly the 

receivables_end_month, the receivables_end_month_previous_year.

The problem is that I cannot aggregate because I do need the daily values for other pages...