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.
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],"")
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |