Forum Discussion

TeunVerhagen's avatar
TeunVerhagen
Frequent Visitor
5 years ago
Solved

Formula for total calculation

Hi all,   I am having an issue, tried a lot, but cannot get a solution. This is the situation:   There are two tables.   - One table with Investments and periods, columns: InvestmentID - Start ...
  • stevedep's avatar
    stevedep
    5 years ago

    Hi TeunVerhagen ,

     

    In this case its required to set the right level of aggregation in the productx command. Productx takes a table as a parameter. By giving a table on the level of period you will get the right results.

    Modified Dietz = PRODUCTX(SUMMARIZE('NAV Dietz Table','NAV Dietz Table'[NAV Date Start],'NAV Dietz Table'[NAV Date End]),ROUND([Dietz]+1,2))-1

    Kind regards, Steve. 

     

stevedep's avatar
stevedep
Memorable Member
5 years ago

Can you share some sample data of your tables with expected outcomes. Should be a quick fix.