Quick DAX : Convert to Roman Numerials

Posted by on Aug 9, 2018 in DAX, Power BI | No Comments

One of the biggest holes in DAX today is the lack of a native function that allows you to convert a decimal number to its roman number equivalent.  Excel has a ROMAN() function so I thought it was about time to share one approach to converting decimal numbers to Roman.  I can feel a collective ...

Read More

Composite Model; DirectQuery and Import Data Combined; Evolution Begins in Power BI

With the new announcement of Power BI Desktop release of July 2018 at Business Applications Summit, the break-through feature is the ability to create a composite model. Now you can have part of your Power BI model to come directly from a data source, and another part to be imported. Along with this change, you ...

Read More

Fun with DAX – Tic Tac Toe

Posted by on Jul 17, 2018 in Power BI | 2 Comments

To follow in the spirit of some of my recent blogs, I thought I would have a look to see how feasible it might be to build a Tic Tac Toe game using just DAX and Power BI.  I get pretty close and will detail my approach here in this article.  For starters, here is ...

Read More

Sharing Power BI Reports with Selection of Slicers and Filters; What it Means?

  The most recent feature added in the Power BI service is a great update, which should not be overlooked. You can now share reports and pass the selection of filters and slicers. This ability, which is announced yesterday, open doors to many possibilities. You can now create “report views” for different personas of users. Previously ...

Read More

Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI

Sometimes for tables with too many columns, and also for databases with too many tables, you do need a bit of help to explore the data. As an example; you know that you are looking for a column named “account status”, but the column does not exists in the accounts table. You need to search ...

Read More

Live Machine Learning in Azure Stream Analytics-part 1

Azure Stream Analytics is an event-processing engine that allows users to analyze high volumes of data streaming from devices, sensors, and applications. Azure Stream Analytics can be used for Internet of Things (IoT) real-time analytics, remote monitoring and data inventory controls. However, Azure Stream Analytics is another component in Azure, that we were able to ...

Read More

Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX

Parent-child functions in DAX are very useful for parsing an organizational hierarchy or something like a chart of accounts. Usually, for hierarchies that the number of levels is not determined, you need to use a different method, and parent-child functions in DAX are a big help for that type of hierarchies. In this post, you ...

Read More