Forum Discussion

Jeffreyjar's avatar
Jeffreyjar
Helper II
3 years ago

Cannot load data from this visual Calculation error with date table calendar

 

 

Cannot load data from this visual

Calculation error in the measurement. A table of several values was provided while a single value was expected

i get this error when i try to create a measure to have the calendar of  a  specific period 

 

with column paiddate of the table pranking ape

PAIDDATE column is a date type 

 

how can i solve this issue ?

 

Regards

5 Replies

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Hi Jeffreyjar 

      sorry for the late reply.

      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. 
      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

      dates =
      CONCATENATEX (
      CALENDAR (
      FIRSTDATE ( 'pranking ape'[PAIDDATE] ),
      LASTDATE ( 'pranking ape'[PAIDDATE] )
      ),
      'pranking ape'[PAIDDATE],
      UNICHAR ( 10 ),
      'pranking ape'[PAIDDATE], ASC
      )