topic Dax formula in DAX Commands and Tips

Dax formula

pro_x — Mon, 13 Jul 2020 10:41:41 GMT

Hi,

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

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

Re: Dax formula

Anonymous — Mon, 13 Jul 2020 10:51:30 GMT

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!

Re: Dax formula

pro_x — Mon, 13 Jul 2020 11:20:01 GMT

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