Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

TREATAS function not available

I am using Power BI Desktop (January 2020). I am trying to use the TREATAS function. I see several articles online describing this as being available since at least 2017. But when I use it I get the error: "Failed to resolve the name "TREATAS". It is not a valid table, variable, or function name". 

Here is how the measure which gives the error.

 

 

TestMeasure = 
    CALCULATE(
        [Some Other Measure]
        ,TREATAS(
            VALUES('Table1'[DateField1])
            , 'dimDate'[Date]
        )
    )

 

 Can anyone suggest what is wrong?

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , that is strange. Not sure if you can upgrade to the latest version and check.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      The "Power BI Desktop (January 2020)" version is for Power BI Report Server. Is there different functionality in DAX commands available in this version, I wonder?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous TREATAS was available in SSAS before Power BI. Would have to check when it was added. Are you using an RS edition of the Desktop? That might lag even further.

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    It maybe the version issue.You can use the app store version and try again.

     

    Or what result do you want to get with this measure?

    Could you replace it with FILTER function?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.