Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |