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])  
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])