topic Get value of Last Row within an unfixed range in DAX Commands and Tips

Get value of Last Row within an unfixed range

ewu — Fri, 26 Jul 2024 17:24:10 GMT

To the experts:

How could I go from the 1sts column raw data to get results of the 2nd and 3rd column? Thanks so much.

Eleanor

Re: Get value of Last Row within an unfixed range

SachinNandanwar — Fri, 26 Jul 2024 17:45:12 GMT

Output = CALCULATE ( MAX ( 'Table'[Date] ), ALLEXCEPT ( 'Table', 'Table'[Type] ) )

There is one less row for 'A' in my data

Re: Get value of Last Row within an unfixed range

Greg_Deckler — Fri, 26 Jul 2024 17:51:21 GMT

ewu PBIX is attached below signature. You first want to add an Index to your table in Power Query Editor.

Group = VAR __Values = { "A", "B", "C" } VAR __Current = [Raw Data] VAR __Result = IF( __Current IN __Values, __Current, VAR __Index = [Index] VAR __PrevIndex = MAXX( FILTER( 'Table', [Index] < __Index && [Raw Data] IN __Values ), [Index] ) VAR __Result = MAXX( FILTER( 'Table', [Index] = __PrevIndex ), [Raw Data] ) RETURN __Result ) RETURN __Result

Latest Date = VAR __Group = [Group] VAR __Values = { "A", "B", "C" } VAR __Table = ADDCOLUMNS( FILTER( 'Table', [Group] = __Group && NOT( [Raw Data] IN __Values ) ), "__Date", DATEVALUE( [Raw Data] ) ) VAR __Result = MAXX( __Table, [__Date] ) RETURN __Result

Re: Get value of Last Row within an unfixed range

ewu — Fri, 26 Jul 2024 18:11:05 GMT

Crazy! Thanks very much!

Re: Get value of Last Row within an unfixed range

ewu — Fri, 26 Jul 2024 18:13:23 GMT

Even crazier! 🙏🙏

Re: Get value of Last Row within an unfixed range

SachinNandanwar — Fri, 26 Jul 2024 18:40:33 GMT

If it helped then kindly marked it resolved.