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.
Does anyone have suggestions for displaying the highlighted value from
- the 'All Directions Index' value
- at the last month
- in the Plan row
- in a Card visual?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi, @jch ;
You could create a measure as follows ,and you could change "Actual" to "Plan" according to your needs:
Measure =
CALCULATE (
SUM ( [North Index] ) + SUM ( [South Index] ),
FILTER (
ALL ( 'Table' ),
EOMONTH ( [Month], 0 ) = EOMONTH ( TODAY (), -1 )
&& [Actual / Plan] = "Actual"
)
)
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jch
I am not sure if you want the last available value or the last month from the current month. Also, you highlighted the actual row but you mentioned Plan. Try the following measure and insert it in a card visual. You can change "Plan" to "Actual" in the formula if you need
Actual Last Month =
CALCULATE(
LASTNONBLANKVALUE( Table2[Month] , SUM(Table2[All Directions Index] )),
Table2[Actual / Plan] = "Plan"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
it should be fairly easy, easier if you provide sample data in text form. Can you paste the data in text form?
Proud to be a Super User!
Thanks!
Month | Actual / Plan | All Directions Index | North Index | South Index |
Apr 2021 | Actual | 0.17 | 0.07 | 0.10 |
Apr 2021 | Plan | 0.14 | 0.06 | 0.08 |
May 2021 | Actual | 0.19 | 0.09 | 0.10 |
May 2021 | Plan | 0.15 | 0.10 | 0.05 |
Jun 2021 | Actual | 0.21 | 0.11 | 0.10 |
Hi,
You may download my PBI file from here.
Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |