Lets Viz technologies | Top Data Analytics Company | PowerBi | Tableau | Zoho Analytics
Dax Function: FORMAT Category: Text Functions The FORMAT function in Power BI is a DAX text function used to convert numbers or dates into formatted text based on specified formatting strings. This function is versatile, allowing developers to display data in a wide range of styles and formats suitable for reports and dashboards. Purpose The FORMAT function is designed to:
Dax Function: FIXED Category: Text Functions The FIXED function in Power BI is a DAX text function that formats a number as text with a specified number of decimal places. It allows for controlling whether commas are included as thousand separators and ensures the returned result is always a text string. Purpose The primary purpose of the FIXED function is
Dax Function: FIND Category: Text Functions The FIND function in Power BI is a DAX function that locates the starting position of a specific substring within a text string. It performs a case-sensitive search and returns the numeric position of the first occurrence of the substring. Purpose To determine the position of a substring in a larger text string for
Dax Function: EXACT Category: Text Functions The EXACT function in Power BI is a DAX function used to compare two text strings. It checks for an exact match between the two strings, including case sensitivity, and returns a Boolean value (TRUE or FALSE). Purpose The function ensures that two text strings are identical, considering both content and case. Calculations Performed
Dax Function: CONCATENATEX Category: Text Functions The CONCATENATEX function in Power BI is a DAX function used to concatenate (join) text values from multiple rows of a table or the result of an expression evaluated for each row. It allows you to specify a delimiter to separate the concatenated values. Purpose To combine multiple text values or expressions from rows
Dax Function: CONCATENATE Category: Text Functions The CONCATENATE function in Power BI is a DAX function used to join two text strings into a single string. It is primarily used to create new text values from existing data by combining two strings without any delimiter. Purpose To merge two text strings into one, enabling you to format and organize text
Dax Function: COMBINEVALUES Category: Text Functions The COMBINEVALUES function in Power BI is a DAX function used to concatenate two or more text strings into a single string, with a specified delimiter. It is especially useful when creating unique identifiers by merging multiple columns or fields. Purpose To merge text values with a specified delimiter, facilitating operations like creating composite
Dax Function: YEARFRAC Category: Date and Time Functions The YEARFRAC function in Power BI is a DAX function used to calculate the fractional number of years between two dates. This function is useful for financial, academic, or project-based calculations where a fraction of the year is relevant. Purpose Computes the number of years (including fractional portions) between two dates. Type
Dax Function: WEEKNUM Category: Date and Time Functions The YEAR function in Power BI is a DAX function used to extract the year from a given date. It simplifies working with date and time data by isolating the year component for further analysis. Purpose Extracts the year from a date value. Type of Calculations Retrieves the numerical year (e.g., 2025)
Dax Function: WEEKNUM Category: Date and Time Functions The WEEKNUM function in Power BI is a DAX function used to determine the week number of a given date in a year. The week numbers range from 1 (starting from the first week of the year) to 52 or 53, depending on the calendar system used. Purpose To calculate the week
Dax Function: WEEKDAY Category: Date and Time Functions The WEEKDAY function in Power BI is a DAX function that returns the day of the week corresponding to a date, represented as an integer. You can customize the numbering to start from any day (e.g., Sunday or Monday). Purpose To determine the day of the week from a date value. Type
Dax Function: UTCTODAY Category: Date and Time Functions The UTCTODAY function in Power BI is a DAX function that returns the current date in Coordinated Universal Time (UTC), with the time component truncated. Purpose: To provide a consistent UTC-based date, suitable for global reporting and time zone-independent calculations. Type of Calculations: This function is used to generate a Date value
Dax Function: UTCNOW Category: Date and Time Functions The UTCNOW function in Power BI is a DAX function that retrieves the current date and time in Coordinated Universal Time (UTC). Purpose To provide a universal timestamp, unaffected by local time zones, for use in global datasets and calculations. Type of Calculations It generates a DateTime value that reflects the current
Dax Function: TODAY Category: Date and Time Functions The TODAY function in Power BI is a DAX function that returns the current date (without the time portion) based on the system clock of the machine running the Power BI service or desktop. Purpose To dynamically fetch the current date for use in calculations or reports. Type of Calculations It generates
Dax Function: TIMEVALUE Category: Date and Time Functions The TIMEVALUE function in Power BI converts a text string representing a time into a datetime value. Purpose To parse and transform textual time representations into proper datetime formats for calculations and analysis. Type of Calculations Converts text-based time values (e.g., “14:30:00”) into a standard datetime format recognizable by DAX. Practical Use
Dax Function: TIME Category: Date and Time Functions The TIME function in Power BI constructs a time value based on three integer inputs: hours, minutes, and seconds. Purpose To create a valid time value from individual components (hour, minute, second). Type of Calculations This function performs time composition by combining numeric inputs into a single time value. Practical Use Cases
Dax Function: SECOND Category: Date and Time Functions The SECOND function in Power BI extracts the second component from a given datetime value and returns it as an integer between 0 and 59. Purpose To isolate the seconds from a datetime value for precise time-based analysis or calculations. Type of Calculations Time extraction and dissection at the second level. Practical
Dax Function: QUARTER Category: Date and Time Functions The QUARTER function in Power BI extracts the quarter from a given date and returns an integer value (1 to 4) representing the quarter of the year. Purpose Identify the fiscal or calendar quarter in which a specific date falls. Type of Calculations Date segmentation and period grouping based on quarters. Practical
Dax Function: NOW Category: Date and Time Functions The NOW function in Power BI returns the current date and time as a datetime value. Purpose To dynamically retrieve the exact system date and time during data refresh or query evaluation. Type of Calculations Date and time-based calculations with real-time updates. Practical Use Cases Tracking data refresh timestamps. Calculating the time
Dax Function: NETWORKDAYS Category: Date and Time Functions The NETWORKDAYS function in Power BI is used to calculate the number of working days (excluding weekends and optionally holidays) between two dates. Purpose: To determine the effective number of business days between two dates. Type of Calculations: It performs date-based calculations by excluding non-working days like weekends and holidays. Practical Use
Dax Function: MONTH Category: Date and Time Functions The MONTH function in Power BI is a DAX (Data Analysis Expressions) function used to extract the month component from a given date or datetime value. Purpose: To retrieve the month number (1–12) from a date. Type of Calculations: Date-based segmentation and analysis. Practical Use Cases: Filtering or grouping data by month.
Dax Function: MINUTE Category: Date and Time Functions The MINUTE function in Power BI is a DAX (Data Analysis Expressions) function designed to extract the minute component from a datetime or time value. Purpose To isolate the minute portion of a datetime value, ranging from 0 to 59. Type of Calculations Time-based analysis and segmentation. Practical Use Cases Breaking down
Dax Function: HOUR Category: Date and Time Functions The HOUR function in Power BI is a DAX (Data Analysis Expressions) function used to extract the hour component from a datetime value. Purpose To retrieve the hour as an integer (0–23) from a given datetime or time value. Type of Calculations Time manipulation and analysis. Practical Use Cases Breaking down datetime
Dax Function: EOMONTH Category: Date and Time Functions The EOMONTH function in Power BI is a DAX (Data Analysis Expressions) function that calculates the last day of a month after adding or subtracting a specified number of months to a given date. Purpose To determine the end-of-month date based on a given date and an offset in months. Type of
Established in 2020, Lets Viz Technologies provides a full range of high-quality data analysis and data visualization services. We are also an authorized Zoho Partner.
Sitelinks
