How to Get the Current Month in Power BI



Guide

  1. Select your visual and go to the 'Modeling' tab.

  2. Select 'New measure'.

  3. Type the DAX formula to get the current month.

  4. Click the check icon to apply and commit changes.

  5. The new measure will be automatically added to your 'Data' pane. Click on it and add it to your visual.

  6. Following these steps gives you the current month as a number.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline