Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sajjadansari
Frequent Visitor

DAX Function for sum Multiple Row

Total Sales 2024 = SUMX(CALCULATETABLE('Combine-YTD',FILTER('Combine-YTD','Combine-YTD'[TYPE]="Sales")),'Combine-YTD'[Jan-24]+'Combine-YTD'[Feb-24]+'Combine-YTD'[Mar-24]+'Combine-YTD'[Apr-24]+'Combine-YTD'[May-24]+'Combine-YTD'[Jun-24]+'Combine-YTD'[Jul-24]+'Combine-YTD'[Aug-24]+'Combine-YTD'[Sep-24]+'Combine-YTD'[Oct-24]+'Combine-YTD'[Nov-24]+'Combine-YTD'[Dec-24])
1 ACCEPTED SOLUTION
shafiz_p
Super User
Super User

Hi @sajjadansari ,
Why not just unpivot your data table and create three columns such as Type, Month-Year, Sales. Unpivoting your data can indeed simplify your DAX calculations and make your data model more flexible. By unpivoting, you transform your wide table (with one column per month) into a long table (with one column for months and another for values). This approach can make it easier to perform time-based calculations and aggregations.

If you want to unpivot, go to power query > Select the columns for the months (e.g., Jan-24 to Dec-24) > Right-click on the selected columns and choose Unpivot Columns. > This will transform your data into a long format with columns for Attribute (month) and Value (sales amount) > Rename the Attribute column to Month-Year and the Value column to Sales > ClickClose & Apply to load the transformed data back into Power BI.

However, if you want maintain wider table, then you can try this:

 

Total Sales 2024 = 
SUMX(
    FILTER(
        'Combine-YTD',
        'Combine-YTD'[TYPE] = "Sales"
    ),
    'Combine-YTD'[Jan-24] + 'Combine-YTD'[Feb-24] + 'Combine-YTD'[Mar-24] + 
    'Combine-YTD'[Apr-24] + 'Combine-YTD'[May-24] + 'Combine-YTD'[Jun-24] + 
    'Combine-YTD'[Jul-24] + 'Combine-YTD'[Aug-24] + 'Combine-YTD'[Sep-24] + 
    'Combine-YTD'[Oct-24] + 'Combine-YTD'[Nov-24] + 'Combine-YTD'[Dec-24]
)

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

 

Best Regards,
Shahariar Hafiz

 

View solution in original post

3 REPLIES 3
shafiz_p
Super User
Super User

Hi @sajjadansari ,
Why not just unpivot your data table and create three columns such as Type, Month-Year, Sales. Unpivoting your data can indeed simplify your DAX calculations and make your data model more flexible. By unpivoting, you transform your wide table (with one column per month) into a long table (with one column for months and another for values). This approach can make it easier to perform time-based calculations and aggregations.

If you want to unpivot, go to power query > Select the columns for the months (e.g., Jan-24 to Dec-24) > Right-click on the selected columns and choose Unpivot Columns. > This will transform your data into a long format with columns for Attribute (month) and Value (sales amount) > Rename the Attribute column to Month-Year and the Value column to Sales > ClickClose & Apply to load the transformed data back into Power BI.

However, if you want maintain wider table, then you can try this:

 

Total Sales 2024 = 
SUMX(
    FILTER(
        'Combine-YTD',
        'Combine-YTD'[TYPE] = "Sales"
    ),
    'Combine-YTD'[Jan-24] + 'Combine-YTD'[Feb-24] + 'Combine-YTD'[Mar-24] + 
    'Combine-YTD'[Apr-24] + 'Combine-YTD'[May-24] + 'Combine-YTD'[Jun-24] + 
    'Combine-YTD'[Jul-24] + 'Combine-YTD'[Aug-24] + 'Combine-YTD'[Sep-24] + 
    'Combine-YTD'[Oct-24] + 'Combine-YTD'[Nov-24] + 'Combine-YTD'[Dec-24]
)

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

 

Best Regards,
Shahariar Hafiz

 

Dear Mr. 

Shahariar Hafiz

i shared DAX Function to summing up multiple column, ( i am not looking solution) its already a solution.

 

Thanks for Understanding.

 

Mr. 

Shahariar Hafiz

i shared Solution (DAX Function) not a Problem.

Thanks for Understanding.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.