Forum Discussion

janwillem's avatar
janwillem
Frequent Visitor
9 years ago

Incorrect Representation of Data

I have made following formulas: 

  • Day last invoice = LASTDATE ( 'Sales Master' [Posting Date])
  • Days in-active = DATEDIFF ( [Day last invoice]; [Today]; DAY )

I have made following matrix:

Now I become in the matrix on one line more measures but it should be one.

Example: Customer 2417 - there must be only in column "< 30 days" a measure, because this is the last invoice.

Why are there in the other columns a measure?

Whats fould in the formula?

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi janwillem,

     

    This is trick of context. If there is a value of "lastdate" of "<30days", "30<90days", etc. , there will be a result. Try this formula please.

    Day last invoice =
CALCULATE (
    LASTDATE ( 'Sales Master'[Posting Date] ),
    ALL ( 'Sales Master'[Posting Date] )
)

    If you still have issues, please post a little sample.

     

    Best Regards!

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi janwillem,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale