How do I define a value that can be used as a constant in multiple places (like measures)

[loganwol]

Hi,

I'm looking to use a constant value (which is a date) that i can edit and update so that I can change my report to only show data relevant to Today - (Constant Value).

Bit of context, I have a report for current candidates hiring and their respective status in the "queue". I periodically send out the report (every week but sometimes it might becomes the last 10 days). I have a few measures such as total number of candidates which is easy but I also have some measures that has to show number of incoming candidates in the last n days. Right now I end up manually editing the measure to a specific value and have realized I forget one of the places at least.

I thought I can create a manual table with the value and then update it but soon realized that manually created tables in PBI are not updateable.

Any other way to accomplish this?

Regards 

[v-haibl-msft]

@loganwol

I think you can also do it with Query Parameters. I’d like to give a simple sample. I assume we have a table like below.

We can create a parameter and enable load to make it available to be referenced later.

Now we can create a measure with following formula. And the parameter can be edited later.

UsersForCurrentDate = 
CALCULATE (
    SUM ( Table1[users] ),
    FILTER ( Table1, Table1[Date] = VALUES ( Parameter1[Parameter1] ) )
)

Best Regards,

Herbert

[loganwol]

Interesting, I was looking to use the query parameters. The Enable load flag was the part i was missing. Will give it a try.

[Greg_Deckler · Accepted solution]

Just create a measure like this:

TheAnswertotheUltimateQuestionofLifetheUniverseandEverything = 42