cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Silver_75 Frequent Visitor
Frequent Visitor

Missing payments and payments not due

I would like to request support for the creation of two measures in dax regarding missing payments and payments non due in a months

 

I have tree tables

 

  1. Client ID (dimension)
  2. Payments table (orders table) (dimension)
  3. Calendar (dimension)Main information in Client ID
  4.  

client ID

date_of_first_payment

scheduling_of_payment

1

26/05/2017

Monthly

2

14/04/2014

Annual

3

08/06/2017

Monthly

4

26/10/2016

Annual

5

10/03/2017

Quartely

 

And in payments tables

 

client ID

date_order

revenue

1

26/05/2017

50

1

26/06/2017

50

1

28/08/2017

50

1

28/09/2017

50

2

14/04/2014

300

2

14/04/2015

300

2

16/04/2016

300

2

16/05/2017

300

2

16/05/2018

300

3

08/06/2017

10

3

08/07/2017

10

3

08/08/2017

10

3

08/09/2017

10

3

08/09/2017

10

4

26/10/2017

100

4

26/10/2017

100

4

26/10/2017

100

5

10/03/2017

30

5

10/06/2017

30

5

10/12/2017

30

 

 

FullDate

CalendarYearMonth

14/04/2017

2017-04

15/04/2017

2017-05

16/04/2017

2017-06

17/04/2017

2017-07

18/04/2017

2017-08

19/04/2017

2017-09

20/04/2017

2017-10

  
  

16/08/2018

2018-08

 

 

qualitative evidence:

Client 1 – scheduling monthly - missing payment in 2017-07

Client 2 - scheduling annual – missing payment 2017-04, but he changes months of payment, so in 2018-04 it’s not missing payment, because has changed

 

Client 3 - scheduling monthly – any evidence

Client 4 - scheduling annual – missing payment 2017-10

Client 5 - scheduling quartely – missing payment 2017-09

 

 

My goal is to count for each CalendarYearMonth clients with missing payment based oh their scheduling or payment not due.

Eg.

 

2017- 07 Client 1 is missing payment, Client 2, Client 4, Client 5 not due …

 

how can i write this count in dax, please?

thanks

 

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Missing payments and payments not due

Hi @Silver_75 

Do you import data into Power BI Desktop or direct query/connect live?

If you use import, you could see the same three view "report"/"table"/"relationship" and  the icons enable in Home menu bar  as mine.

3.png

It's import to know that for me because some transformations or dax only support in import mode.

 

Best Regards
Maggie

 

 

Silver_75 Frequent Visitor
Frequent Visitor

Re: Missing payments and payments not due

I've imported the values into PowerBi

Silver_75 Frequent Visitor
Frequent Visitor

Re: Missing payments and payments not due

Immagine.png

 

hi @v-juanli-msft 

please find attached my model

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,085)