DATESINPERIOD: table of multiple was supplied where a single value was expected (But it wasn't...)

[AlexanderRbt]

Hello,

I am trying to get this function to work:

period = DATESINPERIOD('Calendar'[Date], MAX(engagement[updated_at]), 3, DAY)

The first argument is a date table that I created using this function: 

Calendar = CALENDAR(DATE(2018,1,1),DATE(2022,12,31))

The second is from my data, containing many dates with a time stamp. When I evaluate MAX(engagement(updated_at) I get exactly one value with a timestamp).  Arguments #3 and #4 are number of intervals, and the interval.

I am fairly certain, that I am not passing a table into the function, however, PBI tells me this: "A table of multiple values was supplied where a single value was expected."

I kindly ask for advice what I am doing wrong here and how I can pass a single value into this function.

thx

Alexander

[parry2k]

@AlexanderRbt sorry missed not, yes only scalar value not a table. Will fix the reply to avoiding confusion. 🙂

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@AlexanderRbt in your example datesinperiod is returning a table, it is returning 3 rows of data based on max date, and you cannot return a table in a measure, it has to be a scalar value so that error does make sense.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[AlexanderRbt]

Dear @parry2k 

Thank you for taking the time to respond to me. Do I understand correctly that a measure cannot contain a table, but must contain a scalar. Your sentence was maybe missing a 'not'?

That would make sense then. Your help is very much appreciated.

Thx

Alexander