Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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