Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Just create a measure like this:
TheAnswertotheUltimateQuestionofLifetheUniverseandEverything = 42
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
Interesting, I was looking to use the query parameters. The Enable load flag was the part i was missing. Will give it a try.
Just create a measure like this:
TheAnswertotheUltimateQuestionofLifetheUniverseandEverything = 42
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |