Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to return a columns first non blank value.
LastLogon = FIRSTNONBLANK('TestReport'[Account_Name], 1) & " was the last to logon."
Unfortunately, it returns nothing. I can verify the column I'm referring to has at least one value.
Solved! Go to Solution.
The formula you provided should work if the rest value of column Account_Name is Blank(except value "tyler.montney"). Now the formula does not get the expected value, so I assume the rest value of the column Account_Name is not Blank, it is empty("").
In this case, the following formula should work:
LastLogon = CALCULATE ( FIRSTNONBLANK ( 'TestReport'[Account_Name], 1 ) & " was the last to logon.", TestReport[Account_Name] <> "" )
FIRSTNONBLANK ( 'TestReport'[Account_Name], 1 ) +1
use this query
I think this would be solved problem
The formula you provided should work if the rest value of column Account_Name is Blank(except value "tyler.montney"). Now the formula does not get the expected value, so I assume the rest value of the column Account_Name is not Blank, it is empty("").
In this case, the following formula should work:
LastLogon = CALCULATE ( FIRSTNONBLANK ( 'TestReport'[Account_Name], 1 ) & " was the last to logon.", TestReport[Account_Name] <> "" )
How would you compare "blank" and "empty". As in null/nothing blank?
PBDC-LT-16.PBDC.local,,12:45 june/30/2016,,C:\Windows\System32\cmd.exe,,
I can see "empty" being a whitespace as a value. Above is an example of what blank should be (where a comma delimted value has absolutely nothing in it).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |