Forum Discussion

Yanou's avatar
Yanou
Icon for Helper II rankHelper II
3 years ago
Solved

How to spot Last date and enter it in column

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Yanou Try:

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

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Yanou Try:

    Column = 
  VAR __Account = [Account]
  VAR __Table = FILTER('Table',[Account] = __Account)
  VAR __MaxDate = MAXX(__Table,[Date])
RETURN
  __MaxDate
    • Yanou's avatar
      Yanou
      Icon for Helper II rankHelper II
      3 years ago

      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

    • Yanou's avatar
      Yanou
      Icon for Helper II rankHelper II
      3 years ago

      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