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_HchaimeHelper III
Helper IIIHow 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?