cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
damobrowny Regular Visitor
Regular Visitor

Invoices Raised after end of Month

Hello, I have the below data in a table. I need to create a column in a matrix visual that shows the value of an invoice if the invoice was created after the end of the month. cih-date will be any date in a month but will not go over the last day of that month but the cih-printed date can go past the end of a month as we do not close that month till a later date the following month. In the example below we didn't close May 2017 billing till the 10th of June so line number 1 should flag up but line number 2 is fine

 

cih-invoicecih-datecih-printed
1111131/05/201706/06/2017
1111222/05/201722/05/2017

 

I hope this makes sense? TIA

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Invoices Raised after end of Month

Try:

 

Column = IF([cih-printed]>EOMONTH([cih-date],0),TRUE(),FALSE())

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Invoices Raised after end of Month

Hi @damobrowny 

You may try to get a measure like below:

Measure =
IF ( MAX ( Table[cih-printed] ) > EOMONTH ( MAX ( Table[cih-date] ), 0 ), 1 )

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User
Super User

Re: Invoices Raised after end of Month

Try:

 

Column = IF([cih-printed]>EOMONTH([cih-date],0),TRUE(),FALSE())

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Invoices Raised after end of Month

Hi @damobrowny 

You may try to get a measure like below:

Measure =
IF ( MAX ( Table[cih-printed] ) > EOMONTH ( MAX ( Table[cih-date] ), 0 ), 1 )

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
damobrowny Regular Visitor
Regular Visitor

Re: Invoices Raised after end of Month

Brilliant, thanks so much @Greg_Deckler