Time Intelligence Functions (DAX)

powerpivot, DAX Functions

Hi there,

 


In this post, we will discuss about one of the types of DAX Functions. These functions basically supports the needs of Business Intelligence Analysis. These functions will help to manipulate data using time periods.

 

Series of Functions in Excel

TYPES OF DAX:

  • DATE AND TIME FUNCTIONS
     
  • FILTER FUNCTIONS
     
  • INFORMATION FUNCTIONS
     
  • LOGICAL FUNCTIONS
     
  • MATHEMATICAL AND TRIGNOMETRIC FUNCTIONS
     
  • STATISTICAL FUNCTIONS
     
  • TEXT FUNCTIONS
     
  • TIME INTELLIGENCE FUNCTIONS
 
TIME INTELLIGENCE FUNCTIONS:

Full story »

Excel Songs on Youtube

weekend-special, Commerical ad

Hi there,


I was browsing through the youtube channel to learn new excel findings. But, I came across few songs composed on excel, how crazy people are,. ) :  I actually found 4 videos on Excel. However, Mr.Excel has already listed Top 10 Excel Songs in his website. It was amazed me seeing a very good collection. I am very excited to share those creativities with you as well. 

 

Excel Songs Composed by Excel Lovers !!!

Hoping you also like the way I did, here you go:

Full story »

Types of DAX Functions (Power Pivot)

powerpivot

Hi there,

 


This post is very expensive if you learn because the topic here contains such a great weightage. Which is "Types of DAX Functions". Thinking, you already know Data Analysis Expression is a part of Power Pivot feature of Excel. 

The way excel has different types of functions, even powerpivot has different types of functions. If you know which function falls under which type/category it is easy to grab the function when we are in such scenario.

Here I will be sharing the types of DAX functions. And, in the next post, I will share the number of functions falls in each type/category.

 

So, here we go:

Full story »

How to Filter Bold Cells in Excel?

How-to's, Excel Tips

Hi there,

 


Today, I had a little logical challenge. That is, I have an excel sheet with few cells bolded. The client needs me to filter the data based on bold cells. Because client wants to analyze only bold items and provide some stats to his boss. He gave me very less time and the data is almost big.

 

I spent an expensive time on this report and came up with a simple logic. It might help you as well. So, sharing with you.


I find it very challenging, because this is the first time I came across. And, we do not have a direct feature to click and get it done. However, I cracked this challenge using ...

 

The logic used is FIND & REPLACE option.

 

HOW FIND & REPLACE WILL FILTER BOLDED CELLS?

Full story »

20+ PowerPivot Websites on Net

powerpivot

Hi there,

 


In this post, you will find a list of power pivot blogs in the net. These blogs provide dozens of powerful PowerPivot information from their owners. PowerPivot is a trending topic in the Business Intelligence wing.

Excel PowerPivot Logo


Before you browse through the below blogs, if you are new to powerpivot, here are the glimpse of Introduction to PowerPivot ,  the advantages of Powerpivot and the difference between excel and powerpivot here.


Hoping you are gone through the above links, here are the list of PowerPivot (Excel) bloggers who shares their knowledge to the Excel World.

Full story »

Microsoft Excel cannot open or save any more documents

How-to's, Applications

Hi there,


 


I have installed Office 365 in my professional laptop. And, I started opening the files which I prepared using Excel 2010. You don't believe, I was popped up with a very big dialog box like this.

 

Excel Error: Microsoft Excel Cannot Open or Save any more documents
 

I really felt very challenging to get rid of this message for almost 10 - 15 days. Finally, one day a spark happened in my professional life is that all the excel files started opening ( of-course one by one).

 

DID I DO ANYTHING ON THIS?

Full story »

Contact / Help. ©2017 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.