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",""))
this is pseudocoded so you will need to put things together yourself based on naming conventions in your dataset; but I would recommend using an if statement.
RETURN
IF(_Reconciled = "Yes", Calculate([Sum of Net Revenue, _Reconciled), "Different Measure you need to use")
This statement makes the assumption that you are either Yes/No for reconciled, and there are no alternative options. If there are further options you would need to add a subsequent nested IF statement.