Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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