How to Get the Current Month in Power BI

Quick summary

This tutorial shows how to get the current month in Power BI by creating a DAX measure using the Modeling tab. Following these steps returns the current month as a number that can be added directly to any visual in your report.

Steps

1. Select your visual and go to the Modeling tab.
2. Select New measure from the Modeling tab ribbon.
3. Type the DAX formula to get the current month into the formula bar.
4. Click the check icon to apply and commit your 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 ready to use in your Power BI report.