Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to use the SAMEPERIODLASTYEAR DAX Time Intelligence function.
Continue readingTag Archives: DAX Formula
MAXX and MINX DAX Iterator Functions
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the DAX iterator function called MAXX. Let’s get started MAXX Function returns the largest numeric value or the largest string that result from evaluating an expression for each row in a table MAXX Syntax: =MAXX(table, expression) MINX Function returns the smallest numeric value […]
Continue reading
Power BI: YEARFRAC DAX Function
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the YEARFRAC DAX Function. Let’s get started YEARFRAC DAX function calculates and returns the fraction of the year represented by the number of whole days between two dates. YEARFRAC DAX function uses datetime format in lieu of the serial numbers that is used in […]
Continue reading
CROSSJOIN In SQL Server
Welcome to Excel Jet Consult blog post. In this tutorial, we want to replicate CROSSJOIN performed in Power BI Power Query and Power BI DAX. Let’s get started Kindly click on the link to be redirected to the blog post on how to CROSS JOIN using Power Query and Power BI DAX The first thing we must do is load […]
Continue reading
How To Perform CROSSJOIN In Power Query & Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to perform CROSSJOIN in Power Query and Power BI DAX. Let’s get started CROSSJOIN returns a table that contains the Cartesian product of rows from all tables in the arguments. The columns in the new table are all the columns in all the argument tables CROSSJOIN […]
Continue reading