How to reference, in a Power Pivot measure, to a single fixed value present in a table

[carloP24]

Hi everyone,

I'd like to preface that I inserted this post also in the Power Query forum, since I thought it could be more coherent for this topic, but it was pointed out to me that this is more of a DAX forum topic (that was the other forum I was considering obviously), so I insert it also here.

Here it is the issue:

I have created a measure in Power Pivot on which I need to reference to a single value (fixed value) present in a table (which is 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 (that I have created in anoter table present in the data model, the first one that you can see among the tabs of the first screen), instead of the "30/09/2023" value inserted manually.

Thank you very much for any help!

[some_bih · Accepted solution]

Hi @carloP24 how first rowm, 31/12/2023, should be filtered? Like max of all the Column2 or something else?

[carloP24]

Hi @some_bih! Thank you very much, using MAX function actually resolves my issue! The two dates in the column are always the last quarter and the previous one, so with MAX and MIN you can reference between the two indeed! So, I'm going to accept your hint as a solution, but is it possible to reference to a specific value (e.g. through row, column) of a table? For example if I have four different values instead of two as in this case, or if MAX and MIN approach would not  be sufficient.

Thank you very much once again!

[some_bih]

Hi @carloP24 I am glad if my reply help you. 

In general if there is definition, like data already in columns, wanted output (later somehow input) shoud not be issue