Obtain the total by group using Select() .... I think it's with select() :p

[Juan_Gutierrez]

I have a table where all the records can be of type A(Wallet) or type B. (Mineros)

I need to be able to select a date and have it tell me the total of A and B so I can graph both.

It is clear to me that a select would be something similar to this, I think :

Select(Historical1[Ending Balance], AND ([Date] = [_THISROW].[Date], [tipowall] = “Wallet” ,[tipowall]=“Mineros”))

My big question is how do I differentiate the end-of-day balance for type A and type B?

This is the data table

Thank you very much for your support