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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kalpana
Helper I
Helper I

Formulas

I want to calculate the sum of three columns in Power BI(Query). Please help me.

1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

Cool,

 

Create one Measure using DAX. 

 

Measure = SUM( Column1) + SUM( Column2) + SUM( Column3)

 

 

In Power Query :

 

Add new Column = Column1 + Column2 + Column3

 

 

View solution in original post

3 REPLIES 3
RaghavPBI
New Member

Hi ,

 

I am trying to calculate average of a column which has the value in DD:HH:MM format. I use the formula 

 

    - Avg.Validation to Submission TAT = Format(AVERAGE('GRO Productivity'[Validation to Submission TAT]),"DD:HH:MM").

 

However, if the result is taking a default value of 31 to the DD part of the result if average is less than 24 hours and also when a filter is applied to show the result for a part of the data. Please help me how I can solve this

Baskar
Resident Rockstar
Resident Rockstar

Cool,

 

Create one Measure using DAX. 

 

Measure = SUM( Column1) + SUM( Column2) + SUM( Column3)

 

 

In Power Query :

 

Add new Column = Column1 + Column2 + Column3

 

 

Yeah got it .Thankz

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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