Forum Discussion

dskeane's avatar
dskeane
Helper I
8 years ago
Solved

If Statement

Looking to figure out a solution with multiple If statements. Scenario below.    Example, I have a column called ProjectScope / LaborBilling "Labor billing reflects the total revenue associated wit...
Need Help
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi dskeane

     

    Have you considered creating a calculated column that incorporates that logic?

     

    And then you can create simple measures over the new column.

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi dskeane

 

Have you considered creating a calculated column that incorporates that logic?

 

And then you can create simple measures over the new column.

  • dskeane's avatar
    dskeane
    Helper I
    8 years ago

     This will get me on the right track, however I am running into an issue with the error in the screen shot. T&M is coming from another colum not related to my formula?

     

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      Hi dskeane

       

      What is the datatype of your [LaborBilling] column?

      • dskeane's avatar
        dskeane
        Helper I
        8 years ago

        LaborBilling Data Type:Text Format:Text