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 have a question about the Sumx function, I want you to add me for example only the sales of each date, such as: "12/08/2023"
I appreciate your help
Hey,
not sure if I understand your question correctly, but this will do the trick:
measure =
SUMX(
VALUES('<tablename>'[Date])
, CALCULATE( SUM( '<tablename>'{Sales])
)
But maybe you are looking for this:
measure =
SUMX(
VALUES('<tablename>'[Date])
, CALCULATE( SUM( '<tablename>'{Sales] ) , KEEPFILTERS( '<tablename>'[Date] = '2023-09-25' ) )
)
If none of the above is returning what you are looking for, please provide a visual showcasing the requirement.
Regards,
Tom
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 |
---|---|
98 | |
97 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |