Help with formula including SWITCH, TRUE, ISBLANK
Hey guys, I have this column called COOKIE_ID and a column VISIT_ID. I want to figure out if a visitor (identified by COOKIE_ID) comes for the first time or is a returning visitor or an annonymous visitor. For this I figured I write the following formula: Cookie Status = VAR SelectedDateRange = DATESBETWEEN ( 'OD - All Page Visits Portal'[PAGE_LOAD_DATE], MIN ( 'OD - All Page Visits Portal'[PAGE_LOAD_DATE] ), MAX ( 'OD - All Page Visits Portal'[PAGE_LOAD_DATE] ) ) VAR CookieVisits = CALCULATETABLE ( VALUES ( 'OD - All Page Visits Portal'[COOKIE_ID] ), ALLEXCEPT ( 'OD - All Page Visits Portal', 'OD - All Page Visits Portal'[COOKIE_ID] ), SelectedDateRange ) VAR VisitCount = CALCULATE ( DISTINCTCOUNT ( 'OD - All Page Visits Portal'[VISIT_ID] ), ALLEXCEPT ( 'OD - All Page Visits Portal', 'OD - All Page Visits Portal'[COOKIE_ID] ), SelectedDateRange ) RETURN SWITCH ( TRUE (), ISBLANK ( 'OD - All Page Visits Portal'[COOKIE_ID] ), "Anoniem", VisitCount > 2, "Terugkerend", VisitCount = 1, "Nieuw", "Onbekend" ) For some odd reason though I can't select the column COOKIE_ID in ISBLANK. See picture below What am I doing wrong here?
Help with ISBLANK function
Hope someone can help with this ISBLANK function: # Tables with no person assigned = CALCULATE(DISTINCTCOUNT(responsibility[table_id]),(responsibility[role_id]="Engineer" && ISBLANK(responsibility[user_id]))) It is currently not returning a number, so I must have done something wrong here. Appreciate any help!Lookup value in a column and fill new column in same table
Hello, I am new with DAX and I am having some issues with the following: 1. Table has a column 'first_visit' (date type) with some null values; 2. some rows with same 'id' have column 'first_visit' with data and other rows have null values Output desired: I have tried LOOKUPVALUE, ISBLANK functions but I am having some syntax problems. Thank you in advance for your help.
