Forum Discussion

ganeshsanap's avatar
ganeshsanap
New Member
6 years ago
Solved

Get Latest Non Blank Value from Table

How can I get the latest Non Blank temperature value based on the (latest/earliest) ReadingDateTime column ? (Output should be 38 from below table). I need to show this value on Card visual. Is it ...
Need Help
  • ganeshsanap's avatar
    ganeshsanap
    6 years ago

    amitchandak ,

     

    After using the formula you mentioned it is throwing an error:

     

    "A single value for column 'Temperature' in table 'TableName' 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."

     

    So I have used below formula:

    = LASTNONBLANKVALUE('Table'[ReadingDateTime], SUM('Table'[Temperature]))
ganeshsanap's avatar
ganeshsanap
New Member
6 years ago

amitchandak ,

 

After using the formula you mentioned it is throwing an error:

 

"A single value for column 'Temperature' in table 'TableName' 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."

 

So I have used below formula:

= LASTNONBLANKVALUE('Table'[ReadingDateTime], SUM('Table'[Temperature]))