Forum Discussion
Help with date filter
Hi, guys! I need help with dates.
In my dash, I have a date filter and I need to show some infos, they are, Day results, month results and year to date results. But when I filter one date, ex 30/11/2021, the dash show in all big numbers (day, month and year to date) only the day info. How can I to do?
2 Replies
jaipalResolver III
mmatheuscc123 you need to run the totals for Month and Year to day. Then you able to see the correct figures.
you can do this through DAX or Power Query.
Follow the links
For DAX:
https://community.powerbi.com/t5/Desktop/Running-total/m-p/502657
For Power Query:
v-zhangtiCommunity Support
Hi, mmatheuscc123
Can you provide example diagrams and the output you expect? Sensitive information can be removed in advance.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.