DAX aggregation data

[michalpribyl]

Hi all,
I have a a table with invoices called "Data" - columns(Customer_name,amount,issued_date,duedate,paid_date, invoice no.)

I would like to have result:
for every day - Amount which is after due date based on customer. 

I created a calendar table with Column DATE

KALENDAR = CALENDAR(calculate(min(DATA[ISSUED_DATE])),CALCULATE(max(DATA[PAID_DATE])))

And I created a new column

Total = CALCULATE(

sum(DATA[AMOUNT]),

FILTER(DATA,DATA[PAID_DATE]>=KALENDAR[Date]),FILTER(DATA,DATA[PAID_DATE]<=KALENDAR[Date])

Work fine, but I woul like to a see a result based on date and customer together.  Do you have any advice for me in this topics?
Thank you

[Anonymous]

Hi @michalpribyl,

Can you please share some dummy data with a similar data structure to test? It should help to test coding formula.

How to Get Your Question Answered Quickly 
In addition, you can also take a look at the following blog for some common scenarios. (start date, end date part)

Before You Post, Read This  

Regards,

Xiaoxin Sheng

[amitchandak]

@michalpribyl , Once you create a date table, you join with all dates. On active and other inactive. Now you can activate using userelation. Then there will no need to this between date. Similarly, if the customer is in the same table or in joined table it will filter automatically.

For use relation example refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...