Forum Discussion
Help with VAR statement (result)
jj
I am trying to add another option to my "return" statement below. I have the answer for if the first VAR statement is true...now I need show what the result be if the second VAR statement is t...
CNENFRNL Anonymous Ashish_Mathur Samarth_18 Thanks all for your help. In the end, I was able to get it to work with this which was a lot simpler than I thought.
Net Revenue (not including current month) =IF(SELECTEDVALUE('Net Revenue Table'[Reconciled?]) = "Yes",[Sum of Net Revenue],IF(SELECTEDVALUE('Net Revenue Table'[Reconciled?]) = "No","Pending",""))
CNENFRNL Anonymous Ashish_Mathur Samarth_18 Thanks all for your help. In the end, I was able to get it to work with this which was a lot simpler than I thought.
Net Revenue (not including current month) =
IF(SELECTEDVALUE('Net Revenue Table'[Reconciled?]) = "Yes",[Sum of Net Revenue],IF(SELECTEDVALUE('Net Revenue Table'[Reconciled?]) = "No","Pending",""))