topic Re: Getting max value of a column fixed for every row in DAX Commands and Tips

Getting max value of a column fixed for every row

Nini1 — Thu, 23 Dec 2021 14:23:16 GMT

Hello everyone,

I'm a new user of Power BI and need your help to solve the problem.

I have a data of customer who have unique identifier and corresponding date field.

I want to create field max date per client (takes maximum value noted per each client) and max date(takes maximum value for all the data). I tried to use max (date) function to create the last field but for each row I get different max values but I want max value to be fixed for each row.

Could you please help me to solve this issue?

Thank you in advance

Re: Getting max value of a column fixed for every row

smpa01 — Thu, 23 Dec 2021 14:27:03 GMT

Nini1

use the following measures

maxDatePerClient = CALCULATE ( MAX ( tbl[date] ), ALLEXCEPT ( tbl, tbl[id] ) ) maxDateAll= CALCULATE ( MAX ( tbl[date] ), ALL(tbl))

Re: Getting max value of a column fixed for every row

Nini1 — Thu, 23 Dec 2021 14:36:07 GMT

Thank you very much!