Forum Discussion
SumX for specific dates
Hi, I have data loaded in the PowerBi from 2021 to 2026. However, I want the calculations (Sumx and Cumulative) to be done for only 2022 data. I tried using datesbetween with sumx, but it is cal...
I have created a new table by using- calculatetable and datesbetween functions (to filter out only 2022 data).
Then, I have used this table in my measures to get the desired result.
Hi Anonymous,
Can you please post a sample data that we can copy paste and your expected result? Also, why use SUMX and not a regular SUM?
Please refer to this on how the community can help you better - https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer