Card displaying value from last month from a particular column

[jch]

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?

[v-yalanwu-msft]

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.

[Fowmy]

@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"
)

[vanessafvg]

it should be fairly easy, easier if you provide sample data in text form.  Can you paste the data in text form?

[jch]

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.