Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
3 years ago
Solved

Creating a measure on text table

Hi I have a table called XYZ with one column called ABC. IN that column I have home addresses like this   SouthWest Road, 1234   So I want to write a measure to find the location of "," so I can...
Need Help
  • djurecic's avatar
    djurecic
    3 years ago

    Hi lastnn30 ,

     This is because a measure is normally used to do some type of aggregation and calculated column already has the row context to know what record you are referring to and does not require an aggregation like Sum, Max, etc. Here is some additional information: https://endjin.com/blog/2022/04/measures-vs-calculated-columns-in-dax


    For the situation you describe, it seems like calculated column is the way to go.

djurecic's avatar
djurecic
Super User
3 years ago

Hi lastnn30 ,

 This is because a measure is normally used to do some type of aggregation and calculated column already has the row context to know what record you are referring to and does not require an aggregation like Sum, Max, etc. Here is some additional information: https://endjin.com/blog/2022/04/measures-vs-calculated-columns-in-dax


For the situation you describe, it seems like calculated column is the way to go.