Showing end of quarter for totals and whole quarter for transactions

[Anonymous]

So I have 2 tables, one with totals of each month and one with the transactions of each month:

Totals

Quarter	Month	Company	Total
Q1	January	Uber	5000000
Q1	February	Uber	8000000
Q1	March	Uber	1500000

Transactions

Quarter	Month	Company	Total
Q1	January	Uber	600
Q1	February	Uber	150000
Q1	March	Uber	1500

The tables are linked by a dimdate table and by another table with a Company list.

I have a dashboard with a few graphs and tables that use the "SWITCH" formula, so that the person can switch between all metrics in the same page . When displaying Totals, I only want to show the end of the quarter month, so March, but for Transactions I want to show all the transactions of Q1.

Is there a way to do that?

I really would appreciate it, thank you

Thanks

[amitchandak · Accepted solution]

@Anonymous , Assuming you are using date table, data for the last month of selected period

New measure =
var _max = maxx(allselected(Date),Date[Date])
return
calculate(sum(Table[Value]), filter('Date' , eomonth('Date'[Date],0) = eomonth(_max, 0)))

if there are more than one qtr then use allexcept('Date','Date'[Qtr Year])