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