Pull value from table based on date

[spettinger]

I have a table that adds new rows each week based on the date. I need to have a card in my visual that shows the value from the SPI column and one that shows the same but with the CPI column. I have another table that only shows the lastest refresh date. I need to figure out how to get the card to show the SPI for the date that matches the date in the refresh table. 

[v-yangliu-msft]

Hi  @spettinger ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _newdate=
MAXX(
    ALL('Table'),[Date])
var _Spi=
SUMX(
    FILTER(ALL('Table'),'Table'[Date]=_newdate),[SPI])
var _CPI=
SUMX(
    FILTER(ALL('Table'),'Table'[Date]=_newdate),[CPI])
return
"Latest Date" &" : "& _newdate  
&" "&" SPI" &" : "& _Spi
&" "&" CPI" &" : "& _CPI

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523