Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table called sales. It has customer column and their sales(Non summarized) in different column. A customer can have more than one transaction. Here my problem is to create a new column with customer names where their sales more than 100000. I know there's going to be blanks in the new column because we need to get only customers have sales more than 100000 and the rest of the customer willl go into blank . i'm going to use this to some other analysis, thats why i need it as a separate column.
Any Thoughts...!!
Hi,
Share the data and show the expected result.
Hi,
So you want to show the Customer Name in a new column only when the cumulative sales for that CUstomer are > 1500 and it is the last date for that Customer. Am i correct?
Its not date dependant, i just want to show the customer name in new column where cumulative sales greater than $1500 regardless of what date it is.
Thank you..
Hi,
Try this calculated column formula
=IF(CALCULATE(SUM(Data[sales]),FILTER(Data,Data[Customer]=EARLIER(Data[Customer])))>1500,Data[Customer],BLANK())
Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |