Formulas

[kalpana]

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

[RaghavPBI]

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 · Accepted solution]

Cool,

Create one Measure using DAX. 

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

In Power Query :

Add new Column = Column1 + Column2 + Column3

[kalpana]

Yeah got it .Thankz