Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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])
@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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |