This is the DAX function created for the pipeline amount, it only shows the latest amount of a certain ticket number. But, there are certain ticket numbers that the pipeline amount doesn't show up despite it correctly entered on the database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @NMP02 ,
Are you trying to get the [Project Amount] corresponding to the maximum INDEX of each ticket?
If [Pipeline Date] is empty, take the value of [Amount], and also if '[Ticket_Number / PJ Number], [Confidence Level] ) and [Date_Awarded] are empty, then it will be empty?
Please try:
Best regards.
Community Support Team_ Caitlyn