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.
Hello, I am trying to calculate Sales but I do not want to pull sales from current day. I want to start pulling all sales from prior day on back. I do not know how to manipulate NetSales meaure to do so and I also do not want to use slicer. Any help would be appriciated!
Solved! Go to Solution.
You may modify the measure like pattern below:
Net Sales =
CALCULATE (
SUM ( 'FactNetSales'[Amount] ),
FILTER ( 'FactNetSales', 'FactNetSales'[Year] < TODAY () )
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could you please share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
I would like my Net Sales to start calculating from yesterday. From the 26th not the 27th. I am not sure what function to use in order to make this happen. I want to exclude current date going forward so my data wil auto populate to correct sales value.
You may modify the measure like pattern below:
Net Sales =
CALCULATE (
SUM ( 'FactNetSales'[Amount] ),
FILTER ( 'FactNetSales', 'FactNetSales'[Year] < TODAY () )
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |