Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
You could try a measure like this:
Transaction Amount Exch = SUMX ( Transaction, VAR Customer = Transaction[Customer_id] VAR Dt = Transaction[transaction_date] VAR Amt = Transaction[transaction_amount] VAR ExchRate = MAXX ( FILTER ( Exchange, Exchange[Customer_id] = Customer && Exchange[date_from] <= Dt && Exchange[date_to] >= Dt ), Exchange[exchange_rate] ) RETURN Amt * ExchRate )
You could try a measure like this:
Transaction Amount Exch = SUMX ( Transaction, VAR Customer = Transaction[Customer_id] VAR Dt = Transaction[transaction_date] VAR Amt = Transaction[transaction_amount] VAR ExchRate = MAXX ( FILTER ( Exchange, Exchange[Customer_id] = Customer && Exchange[date_from] <= Dt && Exchange[date_to] >= Dt ), Exchange[exchange_rate] ) RETURN Amt * ExchRate )
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
56 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |