Daily DAX : Day 299 TODAY

Power BI DAX TODAY Function

Description

The TODAY function in Power BI DAX (Data Analysis Expressions) returns the current date based on the system date of the computer running the Power BI Desktop or Power BI Service. It takes no arguments and is commonly used for date-based calculations and dynamic reporting.

Syntax

TODAY()

Returns: A date value representing the current date.

Use Case

The TODAY function is used to create dynamic calculations or filters that depend on the current date, such as:

  • Calculating the difference between the current date and another date (e.g., aging of invoices).
  • Filtering data to show records up to the current date.
  • Creating dynamic reports that update automatically based on the current date.

Example

Suppose you have a sales table with a column OrderDate. You can calculate the number of days since each order was placed using:

DaysSinceOrder = DATEDIFF(Sales[OrderDate], TODAY(), DAY)

This measure returns the number of days between each OrderDate and the current date.

Notes

  • The result of TODAY updates automatically when the report refreshes.
  • It is based on the system date of the machine or server running Power BI.
  • Use with other DAX functions like DATEDIFF, DATEADD, or filters for dynamic analysis.

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 65 INFO.TABLEPERMISSIONS

 A metadata DAX function that returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects Syntax INFO.TABLEPERMISSIONS(<RestrictionName>,<RestrictionValue>) Returns a table with the following fields Field Type ID Integer RoleID Integer TableID Integer FilterExpression String ModifiedTime DateTime State Integer ErrorMessage String MetadataPermission Integer https://dax.guide/info-tablepermissions/
Read more

Daily DAX : Day 55 PV

A financial DAX function that calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal. Syntax PV(<Rate>, <Nr_of_Periods>,<Payments_per_period>,<Future_Value>,<Type>) https://dax.guide/pv/
Read more