Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX to filter tables by regular expression

Hello,   I have following DAX code where I simply filter table gl by another table 'Sheet1' and sum values from gl: Actuals = CALCULATE(SUM('public gl'[movement]),FILTER(ALL('public gl'[gl_code],...
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

Try to use Left dax code in a filter, something like this:

filter(Sheet1,left(Sheet1[gl_code],1)=1&&left(Sheet1[gl_code],1)=2)

 

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

Appreciate your Kudos🙏!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Actually left DAX will not help here becouse gl_code could be 1*, 15* or full account 155 so in case of * it need to get all subaccounts.

     

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous 

       

      Can you share a sample of your data here? [In a Table Format]

       

      Appreciate your Kudos!!