Create Card of newest value per date selected

[Anonymous]

hello i have 2 tables

attendance:

Id	Name	Date	Clock in	Clock Out
1	Lebron	06/01/22	07:00	15:00
1	Lebron	07/01/22	07:00	15:00
1	Lebron	08/01/22	07:00	15:00
2	Ari	06/01/22	07:00	15:00
2	Ari	07/01/22	07:00	15:00
2	Ari	08/01/22	07:00	15:00

and employee table:

Id	Name	Date	Payment per hour
1	Lebron	06/01/22	1
1	Lebron	07/01/22	1.25
1	Lebron	08/01/22	1.75
2	Ari	06/01/22	2
2	Ari	07/01/22	2.5
2	Ari	08/01/22	3

i want to create a card on my dashboard where it shows the payment per hour of the month. so in june when i press the dat june it shows me 1 for lebron and 2 for ari. but when i press on july, i want it to change to 1.25 for lebron and 2.5 for ari.

im using the max of payment per hour but not working it only shows me the max . i need help please

note i have a relationship between the 2 tables. i created an index id  : 

New Id Attendance = [Id]&"_"&FORMAT([Date],"YYMM")

New Id Employee = [Id]&"_"&FORMAT([Date],"YYMM")

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

It is recommended to create a calendar table first and you may need to add a filter  in your original measure like：

payment per hour(Ari) = CALCULATE(MAX(employee[Payment per hour]),FILTER(employee,employee[Name]="Ari"))

payment per hour(Lebron) = CALCULATE(MAX(employee[Payment per hour]),FILTER(employee,employee[Name]="Lebron"))

You can also try multi-row card to display you data.

Best Regards,
Community Support Team _ Eason

[SpartaBI]

@Anonymous take a look at this file and let me know if this is waht you meant:
Create Card of newest value per date selected 2022-07-25.pbix

      

Showcase Report – Contoso By SpartaBI

[amitchandak]

@Anonymous , Refer if this can help

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e