Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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
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
)
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 9 | |
| 7 | |
| 5 |