Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Jeffreyjar
Helper II
Helper II

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

 

Jeffreyjar_1-1663346944583.png

 

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 5
Jeffreyjar
Helper II
Helper II

@tamerj1 

 

Sorry... 

 

Jeffreyjar_0-1663421412913.png

 

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
)

tamerj1
Super User
Super User

Hi @Jeffreyjar 
What is the dax code you've been trying?

hi @tamerj1 

 

im using this dax code

 

this the paiddate table below 

Jeffreyjar_0-1663417639121.png

 

 

 

@Jeffreyjar 

There is no dax code!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.