Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I have a sales table that contains these main infos:
Pay Date - The day that the client should pay
Sales Off - The day that the client in fact payed.
When a client has defaulted, the Sale Off cell is empty and today date is greater than the pay date.
I'd like to build a measure that shows how many days late the default clients are. For instance: If a client has a pay date 01/06/2021 and today is 15/06/2021 and also the Sales Off cell is empty, so the client is 14 days late.
Solved! Go to Solution.
@Anonymous
Create the following measure.
Days Late =
Sumx ( Table2,
IF(
TODAY() >(Table2[Pay Date]) &&(Table2[Sales Off]) = BLANK(),
INT(TODAY() -(Table2[Pay Date]) )
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Create the following measure.
Days Late =
Sumx ( Table2,
IF(
TODAY() >(Table2[Pay Date]) &&(Table2[Sales Off]) = BLANK(),
INT(TODAY() -(Table2[Pay Date]) )
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy ,
I got what you meant, however the problem is that I have many different sales in the "table 2" and I'd like to know the default per client
@Anonymous
I modified the formula, insert customer Id or customer name in a table visual and add the measure and try
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |