topic A table of multiple values was supplied where a single value was expected. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-table-of-multiple-values-was-supplied-where-a-single-value-was/m-p/1026949#M13364 <DIV><DIV><SPAN>Any help for below</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Confirmed Daily = var _currentcumulativecases = 'Covid 19 Data'[Confirmed] var _currentdate = 'Covid 19 Data'[Date] var _previousdate = _currentdate-1 var _areacode = 'Covid 19 Data'[Country/Region]var _privouscumulativecases = LOOKUPVALUE('Covid 19 Data'[Confirmed], 'Covid 19 Data'[Date],_previousdate,'Covid 19 Data'[Country/Region],_areacode) var _dailycases = _currentcumulativecases-_privouscumulativecases return _dailycases</SPAN></DIV></DIV> Wed, 15 Apr 2020 09:47:15 GMT Anonymous 2020-04-15T09:47:15Z A table of multiple values was supplied where a single value was expected. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-table-of-multiple-values-was-supplied-where-a-single-value-was/m-p/1026949#M13364 <DIV><DIV><SPAN>Any help for below</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Confirmed Daily = var _currentcumulativecases = 'Covid 19 Data'[Confirmed] var _currentdate = 'Covid 19 Data'[Date] var _previousdate = _currentdate-1 var _areacode = 'Covid 19 Data'[Country/Region]var _privouscumulativecases = LOOKUPVALUE('Covid 19 Data'[Confirmed], 'Covid 19 Data'[Date],_previousdate,'Covid 19 Data'[Country/Region],_areacode) var _dailycases = _currentcumulativecases-_privouscumulativecases return _dailycases</SPAN></DIV></DIV> Wed, 15 Apr 2020 09:47:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-table-of-multiple-values-was-supplied-where-a-single-value-was/m-p/1026949#M13364 Anonymous 2020-04-15T09:47:15Z Re: A table of multiple values was supplied where a single value was expected. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-table-of-multiple-values-was-supplied-where-a-single-value-was/m-p/1027073#M13370 <P>Can you provide more details?&nbsp;</P> Wed, 15 Apr 2020 10:44:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-table-of-multiple-values-was-supplied-where-a-single-value-was/m-p/1027073#M13370 nandukrishnavs 2020-04-15T10:44:48Z Re: A table of multiple values was supplied where a single value was expected. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-table-of-multiple-values-was-supplied-where-a-single-value-was/m-p/1027153#M13373 <A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A> Wed, 15 Apr 2020 11:26:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-table-of-multiple-values-was-supplied-where-a-single-value-was/m-p/1027153#M13373 Anonymous 2020-04-15T11:26:35Z