0

Picking Specific Excel Cell Entry In Power BI and Turning it into A Column

posted on , by Michael Olafusi

Last week, I got a call from a past participant of our Power BI training regarding an issue he was battling. We provide after training support for all our training, which is one huge value most other training providers don't provide, especially those who don't have in-house dedicated trainers with deep consulting expertise. He has system generated reports that look like the following: Which ...

Read More
0

The DAX and Power Query Way to Group By in Power BI

posted on , by Michael Olafusi

Today, I'll be sharing with you the amazing Group By feature in Power Query, and the DAX equivalent I typically use. I have a database of stocks on the Nigerian Stock Exchange, tracking their daily price among other important investment analysis metrics going as far back as 1998. BTW, don't ask me for the data 'cos I won't give it away. It's at the core of our www.nigeriamarketdata.com app ...

Read More
0

How To Create Formula (UDF) That Converts Number or Money Amounts to Words in Naira and Kobo or Dollars and Cents

posted on , by Michael Olafusi

The first time I was asked a question around this was in 2016 at a training I had for eHealth Africa in Kano. A couple of the finance managers wanted to be able to convert money amounts to words with Naira and kobo in appropriate places. Then two weeks ago in Abuja, I got asked the same question by finance team at HSDF and it became obvious to me that it is a problem many people would ...

Read More