Forum Discussion

Chorri21's avatar
Chorri21
Frequent Visitor
9 years ago
Solved

Cumulative Total

Hy,   I had an issue with a latest project for my company. The task was to show the liquidity ratio per month (filtered by the chart of account Id). A formula for calculating the cumulative total w...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Chorri21,

 

I found your measure worked for me.  But I was only working with a very small dataset.

 

Maybe check your GeneralLedger[Date] column is a date time.  Make sure you have the latest version of Power BI.

 

If that doesn't work, perhaps look to use a date/calendar table to build your measure over.

 

In any case here is the super simple version using your code.

 

https://wgtnpowerbi-my.sharepoint.com/personal/phil_wgtnpowerbi_onmicrosoft_com/_layouts/15/guestaccess.aspx?docid=0aba8b1bdbafe4169b9d885434f12cb94&authkey=AX0nhf4bz68JBiYcNzVH46o

  • Chorri21's avatar
    Chorri21
    Frequent Visitor
    9 years ago

    Thank you Phil_Seamark for your replay. Well the issue was in the date format which was imported from the server. There was that option GeneralLedger[Date].[Date] which I had to specify in the code and it has worked well.

    Greetings

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      Nice work!  Well done.