My Problem is i need to include a column whcih would extract last vlaue of any given row regardless of the Header Value.
I do know how to extract in a column using LASTNONBLANK
In excel i used INDEX and CountA.
I cant modify table in any manner.
Go to Solution.
You can add a custom column in Power Query Editor.
Best Regards, Community Support Team _ JingIf this post helps, please Accept it as Solution to help other members find it.
View solution in original post
are these columns -
if not, can you provide raw data and you need column ot measure ?
Below is the data i have highlighted cells which is required in "Get Last Row Value" Column (Solution which is required)
Day1 Day2 ... are column header
In Excel I have used the below formula "INDEX(O7:T7,1,COUNTA(O7:T7))" to extract last row value for each product in Get Last Row Value Column. The Row Data in Days Column can be Number or Text Too
Is there any way we can replicate in power BI by adding column with above Power BI variant formula.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!