empty
2 Topics
EXACTLY what does BLANK() mean in DAX?
I was surprised to see the following expression in Greg Deckler's "Learn Power BI" book: % Utilization = VAR __utilization = DIVIDE([Total Billable Hours], [Total Hours], 0) RETURN __utilization + 0 And my question is about the implications of the last line. Assuming that the VAR expression is returning the same value as BLANK(), then BLANK() is obviously NOT returning a blank character, as adding zero to a character is not meaningful in many computer languages. But Microsoft DOCs only says that BLANK() returns "a blank", which is clearly not true. Apparently BLANK() is a kind of pseudo-NULL, but learning that I can add a number to "nothing" was a surprise. I would appreciate any links or deeper explanations of what's happening above, whether the expression result is equivalent to BLANK() or some other "kind of like NULL" concept. Thanks in advance.Solved1.4KViews0likes2Comments
CALCULATE MIN WHEN DATE IS NOT EMPTY
Data has multiple field 1 text values that are duplicated in some cases and field 1 is always populated. Data has multiple field 2 date values that are populated sometimes for field1 when duplicated or not. I figured out how to get the first occurance of the field 2 date for each field 1 when all the Field 1 rows have field 2 dates. What I need to do is not have the MIN(Field2 Date =EMPTY be included in the Calculation when the Fields 2 date for the same field 1 value is populated AND if all the field 2 date values are EMPTY for a given field 1 value to select 1 of the EMPTY field 2 rows Current formula: First_date = VAR _POLDate = CALCULATE ( MIN ( PO_REQ_DISTRIBUTION[PO_LINE_CREATED_DATE]), ALLEXCEPT ( PO_REQ_DISTRIBUTION,PO_REQ_DISTRIBUTION[PO_NUMBER] ) ) RETURN IF(PO_REQ_DISTRIBUTION[PO_LINE_CREATED_DATE] = _POLDate, "1", "0") The issue is it shows the first EMPTY date instead of the populated date:Solved2.4KViews0likes3Comments