topic Syntax for referencing a single item query using DAX in DAX Commands and Tips

Syntax for referencing a single item query using DAX

mrandall86 — Wed, 10 Jul 2024 13:47:57 GMT

Hi,

I have created a single item query in Power Query:

I'm trying to reference it in some DAX calculations. I'd be grateful if anyone could help me get the correct syntax:

Many Thanks

OwenAuger — Thu, 11 Jul 2024 05:04:51 GMT

I would suggest:

ReportDate = SELECTEDVALUE ( _ReportDate[_ReportDate] )

This returns the single visible value in a column (if there is a single value) otherwise blank (by default).

Does this work for you?

Anonymous — Thu, 11 Jul 2024 06:23:46 GMT

I created a table myself and implemented what you showed in Power Query.

It looks like you want to show the first row of tabular data, and you're going from Power Query to DAX. I think you can create the following Measure.

Measure = FIRSTNONBLANK('Table'[ReportDate],1)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mrandall86 — Thu, 11 Jul 2024 12:56:40 GMT

Thanks so much for taking the time! This works and I understand why, which is nice 👍

mrandall86 — Thu, 11 Jul 2024 12:57:56 GMT

Thanks Yilong,

This works and your instructions were very easy to follow. I appreciate your time and efforts.