Invoices Raised after end of Month

[Anonymous]

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-invoice	cih-date	cih-printed
11111	31/05/2017	06/06/2017
11112	22/05/2017	22/05/2017

I hope this makes sense? TIA

[Greg_Deckler · Accepted solution]

Try:

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

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may try to get a measure like below:

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

Regards,

[Greg_Deckler · Accepted solution]

Try:

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

[Anonymous]

Brilliant, thanks so much @Greg_Deckler