Forum Discussion
Pull value from table based on date
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.
2 Replies
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-p/963216
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/1447523Hi 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" &" : "& _CPI2. 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
