Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
So the problem is I need the minimum values of columns "ENDT", "ENDV", "ENDE" in the "RelevoStart" column, which should exclude null values.
Formula of "RelevoStart" as:
What should I do to be able to make exclude to null value in this calculation? Appreciate in advance any help.
Solved! Go to Solution.
Hi, @javieezy ;
You could create a measure as follow:
Min =
var _min1=MIN(MIN('Table'[ ENDV]),MIN('Table'[ENDE]))
var _min2=MIN(MIN('Table'[ENDT]),MIN('Table'[RelevoStart]))
return MIN(_min1,_min2)
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @javieezy ;
You could create a measure as follow:
Min =
var _min1=MIN(MIN('Table'[ ENDV]),MIN('Table'[ENDE]))
var _min2=MIN(MIN('Table'[ENDT]),MIN('Table'[RelevoStart]))
return MIN(_min1,_min2)
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @javieezy I am wondering if you could Unpivot the Time Columns into a single column. This will allow the following DAX calculations:
MIN of ENDV = CALCULATE ( MIN ( [Unpivot Time Value] ) , [Unpivot Time Attribute] = "ENDV")
MIN of ALL = CALCULATE ( MIN ( [Unpivot Time Value] ) , [Unpivot Time Attribute] in { "ENDV" , "ENDT", "ENDE" } ))
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |