Forum Discussion

Angel's avatar
Angel
Icon for Resolver III rankResolver III
9 years ago
Solved

Total amount current month

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 mont...
  • LaurentCouartou's avatar
    LaurentCouartou
    9 years ago

    Add a calculated column to your date table, that indicates whether the date belongs to the current month. Then filter on that column.

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
9 years ago

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.

Angel's avatar
Angel
Icon for Resolver III rankResolver III
9 years ago

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,

 

  • LaurentCouartou's avatar
    LaurentCouartou
    Icon for Solution Supplier rankSolution Supplier
    9 years ago

    Add a calculated column to your date table, that indicates whether the date belongs to the current month. Then filter on that column.

    • Angel's avatar
      Angel
      Icon for Resolver III rankResolver III
      9 years ago

      LaurentCouartou

       

      Thank you. That's the way i did it