Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Vincent_Huang
New Member

About Power BI Metrics

Is it possible to add date types to the metrics feature of Power BI? It can be used for time alerts and there are many other applications.

1 REPLY 1
MAwwad
Super User
Super User

Yes, it is possible to add date data types to the metrics feature in Power BI. You can create calculated columns with date and time data types, and then use those calculated columns in metrics to track specific date and time information.

For example, you can create a calculated column to extract the month or year from a date column, and then create a metric to count the number of rows with a certain month or year. This can be useful for tracking trends or analyzing data by specific time periods.

Additionally, you can use the DAX function NOW() to track the current date and time, and create metrics that dynamically update based on the current date and time. This can be useful for creating time-sensitive metrics, such as tracking how many items are due in the next 7 days.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors