Column grand total on each row of matrix visual

[askkumar]

Hello Experts

I am building the Matrix visual, where I have the date column and all dates will be displayed in rows in table.

2023-08-26

2023-08-27

2023-08-28

Now I want to add another column that gives me max of date in each row

2023-08-26	2023-08-28
2023-08-27	2023-08-28
2023-08-28	2023-08-28

Tried different measures using max, but unfortunatley unable to get in desired format.

Any help is appretiated

[askkumar]

Thanks experts for the answers, sorry for the late reply.

I have achieved this by using all solutions, my visuals has more than 10 columns and all these columns are affecting the max value.

Hence I achieved by exlcuding some columns from calculation and then taking max and then comparing with max date in dataset then filtered the rows.

var Max_Date_Selected = CALCULATE(MAX(Query1[DATE]),ALLSELECTED(Query1[DATE]))

var Max_date = MAXX(FILTER(Query1,Query1[DATE] = Max_Date_Selected),Query1[DATE])

var Max_Date_Visual = CALCULATE(MAX(Query1[DATE]),ALLEXCEPT(Query1,Query1[DATE],Query1[col1],Query1[col2],Query1[col3]))

return

IF(Max_date = Max_Date_Visual,1,0)

[mh2587]

MAX_DATE = MAXX(ALL(Dates),MAX(Dates[Date]))
--Try this one

[Anonymous]

Hi! 

Do you have an example of a measure yout tried or can you gives us more context of the filtering context? 

For example, if you create a column in your table with the formula:

max_date = MAX('Calendar'[Date])

This gives the maximum value of the column "Date" in my Calendar.  

You can then add this column to your visual 

LMK if this helps

[Greg_Deckler]

@askkumar Try something like: MAXX( ALL('Table'), [Date])