Accruals measure

Anything related to PowerPivot and DAX Formuale
Posts: 1
Joined: Mon Oct 07, 2019 10:17 pm

Accruals measure

Postby kootcha » Mon Oct 07, 2019 10:23 pm


I have two columns with dates (from - to) and a price of a product in a table which should be a source for calculating accruals. Unfortunately I am not able to invent a DAX formula that would work. But it must be a problem of every accountant/controller/analyst in th whole world. :)
I tried calculating sumx of prices per day datesbetween these two columns, but it didn't work.

Posts: 1103
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Accruals measure

Postby MattAllington » Tue Oct 08, 2019 7:12 pm

Well it can be done, but every DAX formula depends on the table structure. I suggest you create a meaningful set of realistic test data an share it along with your expected outcome.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 6 guests