Dax formula

[pro_x]

Hi,

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

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

[harshnathani]

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]

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