Forum Discussion

pro_x's avatar
pro_x
Icon for Helper I rankHelper I
6 years ago

Dax formula

Hi,

 

How can i reference a specific month from new_table column data in this formular:

 

Growth  = divide(sum(table(new_table)),[measure])

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi pro_x ,

     

    Can you share the expected output and sample data.

     

    You can reference the other table using Related function or Lookupvalue Function .

     

    https://dax.guide/related/

    https://dax.guide/lookupvalue/

     

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

    • pro_x's avatar
      pro_x
      Icon for Helper I rankHelper I
      6 years ago

      There are 12 months and each month has a different number under new_table column. I want to be able to calculate a specific month and not the entire new_table column:

       

      Please help me with this formula:

       

      Growth  = divide(sum(table(new_table)),[measure])