Forum Discussion
Joseph_Hchaime
Helper III
Helper IIIBilling and Collection Report Problems
Hi I am having trouble creating a table with the following fields: screenshot is an excel demo: Date Bill Number Amount Billed Amount Collected 01/01/2019 100000 50000 0 02/02/20...
amitchandak
Super User
Super UserJoseph_Hchaime , You need to have a common Bill ID/Number in table two. These two tables should not join with each other
Once you have common bill and date tables; simple sum of columns from both table should do
Joseph_HchaimeHow am I supposed to get the allocation date then if I am going to do more time intelligence dax functions?
For instance. What if I want to know that a specific payment is divided between current year and previous years based on the date of payment?
Can you please show me a relationship diagram of your solution?
- Joseph_Hchaime
there is a common bill number.
ALL bill IDs in the allocations table are found in the bills table. But not necessarily vice versa.