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.
Hi, I need to get the value of last date eventhough it is null. The functions lastdate & Max is not working. They are pulling previous non-zero values. The dataset & result are beow. Can any one help me on this.
Solved! Go to Solution.
Hi @Aruljoy
if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
Hi @Aruljoy
if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
Missed dataset and result are below
Right click on Category on visual and click "show items with no data". It will show you null values against
Proud to be a Super User!
@Aruljoy , Try one of the two
LASTNONBLANKVALUE(Table[rundate],max(table[Value]))
sumx(summarize(Table, Table[Category],"_1",LASTNONBLANKVALUE(Table[rundate],max(table[Value]))),[_1])
You might have to add month year in summarize or visual
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |