Add a card to my visualisation

[Lasa1]

Hi,

I would like to add a card in my visualisation but I am new to powerbi and I need guidance.

Table 1 : Rolling Calendar date ( 1 column)

Date

1 Jan 21

2 Jan 21

3 Jan 21

Table 2: Stock Investment (4 columns)

Date	Cost of Investment	Value of Investment	Gain/Loss
1 Jan 21	100	102	2
2 Jan 21	100	102.50	2.50
3 Jan 21	100	101	-1

Table 3: Bond Investment (4 columns)

Date	Cost of Investment	Value of Investment	Gain/Loss
1 Jan 21	5000	5005	5
2 Jan 21	5000	10000	5000
3 Jan 21	5000	300	-4700

Note that cost of investment column remains unchanged as shows the cost of the investment at acquisition date.

I would like to add a Card in my visualisation that shows the gain and loss of the latest date which in this case will -4701 at 3 Jan 21.

Could you please help?

Thanks

 

[Lasa1]

I found the answer in this thread.

How can I get the last value of a column in my dataset in power bi?

In the given table how to get the last value of a particular column in a dataset Roll No Name Index Score 1 ab1 1 23 2 ab2 2 43 3 ab3 3 42 Here we have to pi...

stackoverflow.com

Thanks