I have added a column “Average” to a table called “Scorecard” which is calculating the average of column “Gross” in a table called “Rounds” using formula: AVERAGE(Rounds[Gross]) This gives me the average for all rows in table “Rounds” I am trying to ...

Would be grateful if someone can debug this expression as it is giving nil return, sum( SELECT( (Miles[Miles Completed]), AND( [DATE] <= [_THISROW].[DATE], MONTH([Date])=MONTH [_THISROW].[DATE] ) ) ) I am trying to show the cumulative miles completed...

Is it possible to write a formula for the initial value of a column to equal the value of the last entry in the same column? In the example I am building the last entry will always be the highest value recorded and it will be the entry for yesterday ...

Hi, This should be an easy one to answer but I’m having a real brain fail with it. I am trying to create a slice which returns the record with the lowest weight in a table. I am using following formula: minrow(“Weights”, “Weight”) where Weights is th...