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...

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi marie_joy it seems that your measure receivables_end_month is related to measure sum_total_receivables_date which is related to calculated column is open?
    If yes, and you really need this calculated column please be focuse on this column and think how to rewrite it.