Forum Discussion
Conditional column PowerBI
Hi Anonymous ,
It is suggested to convert the two columns of time values into time types. Then you can easily calculate the difference.
The measure is this. Then you need to select Time formats as the format of the measure.
Difference =
IF (
MAX ( 'Table'[klaipėda - radviliškis] ) > MAX ( 'Table'[earliest] ),
MAX ( 'Table'[klaipėda - radviliškis] ) - MAX ( 'Table'[earliest] )
)
The result is this.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-stephen-msft Many thanks for your help, one more thing: I created a custom column to return the actual time value if the time exceeds the norm and if it did not, then just return the actual time value, like shown below. If the Time column exceeds 4:30, then it shows difference, if not, it returns the actual time value.
However, i need to display it into the histogram and show the actual value below 4:30 or 4:30 in the green color and then if it exceeds it would add on the column and show it in red, something like that below. Any ideas what measure should be created?
Hi Anonymous ,
Because if you put the value of the time type in the Values of the histogram, there can only be two aggregation operations, Count and Count (Distinct), so I changed it to display the percentage of time.
1.Add an index column and create these calculated columns.
TIME = TIME(23,59,59)Percentage = [klaipėda - radviliškis]/[TIME]below 4:30 or 4:30 = IF([klaipėda - radviliškis]>[klaipėda - radviliškisNorma],[klaipėda - radviliškisNorma]/[TIME],[Percentage])above 4:30 = [Percentage]-[below 4:30 or 4:30]2.Create a Stacked column chart and a martix. Then combine them.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.