How to spot Last date and enter it in column

[Yanou]

Hello,

Please someone help me in my issue. I have accounts in a column and for each account there is a operation date (in an other column). 

I would like, in a calculated column, for each line, that PBI manage to spot the latest date. Then PBI enter the data date in all the Lines of the column who have the same account.

Informations : in the column accounts, the same account can be several times repeat. 

Thanks a lot.

Yannick

[Greg_Deckler · Accepted solution]

@Yanou Try:

Column = 
  VAR __Account = [Account]
  VAR __Table = FILTER('Table',[Account] = __Account)
  VAR __MaxDate = MAXX(__Table,[Date])
RETURN
  __MaxDate

[Yanou]

Hello Greg,

I read your article on "Dealing with Measure Totals". I understand that the measure doesn't make the total in adding the detail lines. You note that one should use Hasnofilter to have the correct total :

Can you please tell me how to add a Hasnofilter function in the folowing measure to have the right total line  ?

Montant financé2 = SUMX (SUMMARIZE ('SAP compta','SAP compta'[Element OTP],'Taux par financeurs'[Financement]

),

'Taux par financeurs'[Financement]*[Dépenses éligibles FAP/FHP V2 (apres T1/Date fin)]

)

Thanks you

[Yanou]

Thank you for your help !

[Yanou]

Hello Greg,

Thanks for the help, I try that this morning. A question, in your formula "VAR __Account = [Account]",  "[Account]" is a measure to create?

Thanks