I'm using the formula
sumx(DISTINCT(Table1[Customer ID]),([Max of TO])) and it works fine - I have the sum of max TO per a disinct Custemer ID,
Unfortunatly the same formula dosent works for onather Value and I cant find why - 'Max of' can't be calcualted
Both are Currency, decimal.
Go to Solution.
@Hris_2013,Glad to hear the issue is solved. You can accept your reply as answer to close this thread.Regards,Lydia
View solution in original post
Please share sample data of your table, and post the formula that you use to create ‘Max of’.
Hi, thank you!
I found how to solve it.
it works good in the first case because excel creates automatically a hide formula for calculation of max of TO…
sumx(DISTINCT(Table1[Customer ID]),([Max of TO]))
for the columns that the abouve formula dosen’t works there is no such hidden formula automaticaly created (i dont know why)
I write it manually and it’s working now.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!