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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors