Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to calculate the sum of three columns in Power BI(Query). Please help me.
Solved! Go to Solution.
Cool,
Create one Measure using DAX.
Measure = SUM( Column1) + SUM( Column2) + SUM( Column3)
In Power Query :
Add new Column = Column1 + Column2 + Column3
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
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |