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 production data that lists sales. I need to calculate Total Sales for anything other than the original sale. Example:
I have Sale Date, Sale Amount, Client Name
I was thinking somehow I need to use
DellProduction = CALCULATE([Sales Total], 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] <> MINA('dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate]))
but keep getting an error
Solved! Go to Solution.
I too don't know what you mean by "other than the original sale", but I can tell you why you are getting an error. The filter argument for your CALCULATE function cannot compare a column with a calculated value the way you have it set up. It needs a hard coded value and could do it this way: 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] <> "12/12/2016"
Otherwise, you will need to wrap the MINA function in a VALUES function. Additionally, you may need to wrap all this inside a FILTER function, but it is impossible to test without any sample data.
I too don't know what you mean by "other than the original sale", but I can tell you why you are getting an error. The filter argument for your CALCULATE function cannot compare a column with a calculated value the way you have it set up. It needs a hard coded value and could do it this way: 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] <> "12/12/2016"
Otherwise, you will need to wrap the MINA function in a VALUES function. Additionally, you may need to wrap all this inside a FILTER function, but it is impossible to test without any sample data.
What do you mean by "anything other than the original sale". Can you provide sample data and some screenshots for better understanding your problem?
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |