1- getting a couple of online sessions to take consultancies for some points in my company's power BI project.
2- the candidate should be able to solve this problem, and explain how:
In the attached pbi file.
The allCusttrans table (showing all transaction for all customers) is linked only with the HH_customer table (customers database).
So, On page “dimitri” : I need to sum all the transactions that a customer made “after” the context filter.
I made 2 measures:
• One to get the last day of the context filter: [filter end date] = max(Date_Table[Date])
and assumed it will give the last date of the chosen month.
Then I wrote: [after filter trx] = sumx( filter(allCusttrans , allCusttrans[Datez]>[filter end date])
I need to get that sum for every customer.
This worked fine for months: ( 4,5,8), BUT didn’t work for the other months (as the customer didn’t have transactions in those months so the system ignored all ) so if I am selecting month no 3, it gives no transactions while it should return the sum of all transactions after end of march.
How can I fix that?