empty
2 Topics
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
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