Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I feel like this should be easy and maybe my brain is just fried today.
I am trying to show my list of projects and the Decision Points Values in a table. However - the Decision points currently exist in a table like this below and I want them to show in a column, so I thought all I needed to do was create a measure to show them. I CANNOT get this measure to function the way I want it to.
Table I'm creating:
Project | Schedule Health | Revenue | Expenditures | Budget | Gate A | Gate B |
Project 1 | X | X | X | X | 1/1/2020 | 1/1/2021 |
Project 2 | X | X | X | X | 1/1/2020 | 5/6/2020 |
Project 3 | X | X | X | X | 5/1/2020 | 12/31/2020 |
The Gates currently exist in the columns:
"Gate" and "Actual/Trend"
Gate | Actual/Trend | Project |
A | 1/1/2020 | Project 1 |
B | 1/1/2021 | Project 1 |
C | Project 1 | |
D | Project 1 |
I thought this would work:
Gate A = CALCULATE(VALUES('PP - Project Status AIM'[Actual/Trend]), FILTER('PP - Project Status AIM', 'PP - Project Status AIM'[DP] = "DP-A"))
Solved! Go to Solution.
Can you use the simplier version of the formula below? Or, do you have to have 'Values' instead of MAX?
Proud to give back to the community!
Thank You!
Can you use the simplier version of the formula below? Or, do you have to have 'Values' instead of MAX?
Proud to give back to the community!
Thank You!
Not Attached to Values 🙂 Just thought that was the right thing to use! Thanks so much, this worked great.
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |