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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Power Pivot reference to a single fixed value present in a table

Hi everyone,


I have created a measure in Power Pivot where I need to reference to a single value (fixed value) present in a table in the data model: the value is a date and I use it for a YEARFRAC calculation within the measure.


In practice, I would need to reference to the value present in the first row - second column of the below table (that is 31/12/2023)...




...within the below measure, instead of the "30/09/2023" value inserted manually.





Thank you very much for any help!

Frequent Visitor

Anyone that could help me with the topic?


Thank you!

You posted DAX question to Power Query forum...

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

I'm aware of it, but I wasn't sure about the exact location of the post given the topic (the data comes from power query tables...). At this point I will also put it in "DAX Commands and Tips" (provided that is the correct forum...). Thank you

Super User
Super User


you can reference one value in Power query.

You can directly extract it this way

= #"Changed Type"[Column2]{0} (first value of column2)

and then use it in a column of your second table






Or you can do it using lists

You need first to extract your value to a list with few steps






use drilldown


and you get your value in a list


then you can use it


If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !





Thank you very much for your help!


Your suggestion was helpful though, but actually what I really need is reference to a value in a query table (the date) within a measure in Power Pivot instead of use "30/09/2023" putted manually (as you can see the "Date" table is present in the data model so that I can use it in Power Pivot).

as you can see here



#"Solution 2 step 1" is not an hardcoded value but the value the value present in the first row - second column of the below table (that is 31/12/2023)




Mmmm, ok, but I would like to know how to reference to that value within my Power Pivot measure (in particular in the YEARFRAC calculation of the measure) and, preferably, how to do it using the original "Date" query table.


Thank you!

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors