https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2774178#M86508 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="403094" data-lia-user-login="Jeffreyjar" class="lia-mention lia-mention-user">Jeffreyjar</a>&nbsp;<BR />What is the dax code you've been trying?</P> Fri, 16 Sep 2022 17:19:52 GMT tamerj1 2022-09-16T17:19:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2774157#M86504 <P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Cannot load data from this visual</P><P>Calculation error in the measurement. A table of several values was provided while a single value was expected</P><P>i get this error when i try to create a measure to have the calendar of&nbsp; a&nbsp; specific period&nbsp;</P><P>&nbsp;</P><P>with column paiddate of the table pranking ape</P><P>PAIDDATE column is a date type&nbsp;</P><P>&nbsp;</P><P>how can i solve this issue ?</P><P>&nbsp;</P><P>Regards</P> Fri, 16 Sep 2022 17:09:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2774157#M86504 Jeffreyjar 2022-09-16T17:09:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2774178#M86508 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="403094" data-lia-user-login="Jeffreyjar" class="lia-mention lia-mention-user">Jeffreyjar</a>&nbsp;<BR />What is the dax code you've been trying?</P> Fri, 16 Sep 2022 17:19:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2774178#M86508 tamerj1 2022-09-16T17:19:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775000#M86592 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp;</P><P>&nbsp;</P><P>im using this dax code</P><P>&nbsp;</P><P>this the paiddate table below&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 17 Sep 2022 12:27:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775000#M86592 Jeffreyjar 2022-09-17T12:27:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775012#M86595 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="403094" data-lia-user-login="Jeffreyjar" class="lia-mention lia-mention-user">Jeffreyjar</a>&nbsp;</P> <P>There is no dax code!</P> Sat, 17 Sep 2022 13:02:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775012#M86595 tamerj1 2022-09-17T13:02:33Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775019#M86596 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp;</P><P>&nbsp;</P><P>Sorry...&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sat, 17 Sep 2022 13:30:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775019#M86596 Jeffreyjar 2022-09-17T13:30:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775039#M86598 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="403094" data-lia-user-login="Jeffreyjar" class="lia-mention lia-mention-user">Jeffreyjar</a>&nbsp;</P> <P>sorry for the late reply.</P> <P>I don't know how your visual is supposed to look like but if you want to return a dynamic set of dates you have two options: either to concatenate the table that contains these days or to place a filter measure in the filter pane of the visual that filters this visual dynamically to the required set of dates.&nbsp;<BR />following is the solution using first option. If you can provide more details of what are planning to achieve I can help you with option 2</P> <P>dates =<BR />CONCATENATEX (<BR />CALENDAR (<BR />FIRSTDATE ( 'pranking ape'[PAIDDATE] ),<BR />LASTDATE ( 'pranking ape'[PAIDDATE] )<BR />),<BR />'pranking ape'[PAIDDATE],<BR />UNICHAR ( 10 ),<BR />'pranking ape'[PAIDDATE], ASC<BR />)</P> Sat, 17 Sep 2022 14:26:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-load-data-from-this-visual-Calculation-error-with-date/m-p/2775039#M86598 tamerj1 2022-09-17T14:26:50Z