topic Dax measure for a specific month in DAX Commands and Tips

Dax measure for a specific month

pro_x — Mon, 13 Jul 2020 12:04:25 GMT

Hi,

I have data that has 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])

Re: Dax measure for a specific month

Anonymous — Mon, 13 Jul 2020 12:25:35 GMT

Hi pro_x ,

Duplicate Questions to https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dax-formula/m-p/1218162#M19702

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Can you tell us what is [measure],

Share sample data in text format

along with expectd output.

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 measure for a specific month

pro_x — Mon, 13 Jul 2020 12:37:57 GMT

Hi, i would like to get the growth rate, I want to use a specific date from Table_2 eg Date 202004, Sales 345

Measure in this case is the total of a different table. I would like to incorporate the specific date from Table_2 into this formula:

I want to calculate percent growth rate using the measure in Table_1 and a specific date from Table_2

Re: Dax measure for a specific month

pro_x — Mon, 13 Jul 2020 13:50:04 GMT

Please help me with this formula:

The new formula is:

Growth = divide(sum(table2[Sales]),[measure])