Forum Discussion

bhelou's avatar
bhelou
Responsive Resident
5 years ago
Solved

Receivable Days aging Dynamic

Hello , I Have receivalbles aging to do , i have made measures for the days still not yet received , now i am trying to make aging 30 - 90 - 180 - 360 - 720 etc ...  for it as from the days shown , ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    bhelou , If it is column 

    calculate([Receivable Balance], filter(Table,Table[Receivable Days]<=30))

     

    In case it is a measure

    IF(([Receivable Days]) <=30,[Receivable Balance],BLANK())

  • amitchandak's avatar
    amitchandak
    5 years ago

    bhelou , Create like


    Receivable Days =  IF([Status] = "Paid" , 0 , datediff( [Invoice Date],TODAY(), day))