Forum Discussion
Dax Help
I am trying to calculate the time it takes one of my customers to go from no revenue to meeting the revenue projection we create when signing them up. I have numbers for what the revenue goal is (Pr...
That got me close, but I get: A single value for column 'Prorated Booking' in table 'Sheet1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
I should have said in the original post that Im working off two different tables here. All the fields are within one table except for the Prorated Bookings, which is another. Would a merge querys option fix that issue?
Please provide sanitized sample data that fully covers your issue.