Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This should be trivial, but I'm dragging the hairs off my head! I can't get to display the most recent value!!!!!! why do I get every other value when I try to filter on last nonblank date?
I have a table, let's say its like this:
Column A has dates
Column B has values. Some values are blank, others are not.
I want to display the last non-blank value of B, in a card visual.
I can't seem to make it happen!!!!! The values in column B are Decimals. What the f should I do?
Solved! Go to Solution.
Hi @vehau1
Create measures
column B = SUM(Sheet2[columnb]) last non-blank date = CALCULATE(MAX(Sheet2[date]),FILTER(ALLSELECTED(Sheet2),[column B]<>BLANK())) FLAG = IF([last non-blank date]=MAX(Sheet2[date]),1,0) last non-blank value = CALCULATE(MAX(Sheet2[columnb]),FILTER(ALL(Sheet2),[FLAG]=1))
Best Regards
Maggie
Please give this a try. I am filtering base table to fetch all Non-Blank Rows based on Values, Then, From filtered table, extracting Max(Date)
Measure 3 = CALCULATE(max('Table'[date]),filter('Table',not(isblank('Table'[val]))))
@vehau1 Please mark this as Solution if any of the provided solution resolved your Problem
Hi @vehau1
Create measures
column B = SUM(Sheet2[columnb]) last non-blank date = CALCULATE(MAX(Sheet2[date]),FILTER(ALLSELECTED(Sheet2),[column B]<>BLANK())) FLAG = IF([last non-blank date]=MAX(Sheet2[date]),1,0) last non-blank value = CALCULATE(MAX(Sheet2[columnb]),FILTER(ALL(Sheet2),[FLAG]=1))
Best Regards
Maggie
Great, thanks! Wasn't as straight forward as I thought, but I will study the codes.
Hi,
This code worked for me:
LastValue = LASTNONBLANK(Table1[Value],"")
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |