Forum Discussion
Solved
Filtering last date for every year
Hello! I have a question and maybe the solution is simple, but I cannot find it. I have different dataset that I import in Power Bi (they are essentially different excel files hosted in a sha...
elmer , if need a new column
LAST ITEM FILTER =
var _year = Dataset[Creation date]
return
IF(Dataset[Creation date]=MAXX(filter(Dataset,year(Dataset[Creation date]) = _year)Dataset[Creation date] ),"Yes","No")For new measure refer my video for two ways
closingbalanceyear , lastnonblankvalue
elmer , if need a new column
LAST ITEM FILTER =
var _year = Dataset[Creation date]
return
IF(Dataset[Creation date]=MAXX(filter(Dataset,year(Dataset[Creation date]) = _year)Dataset[Creation date] ),"Yes","No")
For new measure refer my video for two ways
closingbalanceyear , lastnonblankvalue
It works! Thank you very much!
I just modify:
var _year = Dataset[Creation date].[Year]
and it works perfectly fine!