Forum Discussion
Daily Values from Running Total
Hello, I am attempting to get daily values from the running total. I have three columns Key, Date, Cumulative Cases. I am trying to get the daily values per key. I have attached a picture from ...
Why not using it as a Measure instead of a calculated column. The DAX will work just fine into a measure.
I tired that and I get an error saying:
A single value for column 'Key' in table 'Table' 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.
Did you modify the measure in the picture above to get it work as a Measure? Like in the Return, did you add Sum(Table...)
Try to evaluate your VAR one by one until you get to know which one needs a little modification..... remember to keep the logic of your calculated column.
What function should I use 'Table'[key] since it is a string?