Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello, everybody
First of all, I must say I'm starting with DAX functions. So, maybe it could be easy to solve.
Is there any dax command where I can see the total amount for the current month?.
Many thanks,
Solved! Go to Solution.
Add a calculated column to your date table, that indicates whether the date belongs to the current month. Then filter on that column.
@Angel You need to leverage Group BY and Summarize functions of DAX. So assuming you have Month column and Amount column, you can create new calculated table.
@ankitpatira Maybe I haven´t explained the issue well.
I have the columns you mentioned before. The thing I want to do is showing total amount of the current month in a dashboard. If the month changes, the dashboard have to change the month 'automatically' without user interaction.
Thanks,
Add a calculated column to your date table, that indicates whether the date belongs to the current month. Then filter on that column.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
19 | |
11 | |
10 | |
8 | |
8 |
User | Count |
---|---|
20 | |
13 | |
8 | |
7 | |
6 |