Forum Discussion
Helper IIFind Last Date value eventhough it is null
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.
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!
4 Replies
AruljoyMissed dataset and result are belowDataset
- amitchandak
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
FarhanAhmedCommunity Champion
show Items with no data
Right click on Category on visual and click "show items with no data". It will show you null values against
- v-diye-msft
Community Support
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!
