## DAX : Inventory or Stock Valuation using FIFO

Posted on Dec 3, 2018 in DAX, Power BI

All source files for this article can be downloaded here : A good friend and member of my local Power BI User Group contacted me recently to ask if I might help with a problem he trying to solve in DAX.  He was keen to track the value of items purchased over time in chronological ...

## Fun with DAX – Tic Tac Toe

Posted on Jul 17, 2018 in Power BI

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 ...

## Fun with DAX – Compressing Numeric Sequences to Text

Posted on May 15, 2018 in DAX, Power BI

A recent post on the Power BI community website asked if it was possible to compress a group of numbers into text that described the sequential ranges contained within the numbers. This might be a group of values such as 1, 2, 3, 4, 7, 8, 9, 12, 13:  (note there are gaps) with the ...

## New Series of Time Series: Power BI Custom Visual (Part 6)

Posted on Aug 25, 2017

In the last post, I have explained how to do time series forecast using “Exponential Smoothing” approach in Power BI. I start to explain the main parameters that we need to set up. The main concepts behind of most of these parameters have been explained in previous posts (Post 4, Post 3, Post 2, and ...

## New Series of Time Series: Part 2 (Exponential Smoothing)

Posted on Aug 3, 2017

In the last post , I have explained the main concepts behind the timeseries. In this post, I am going to show how we can forecast for some periods. In the last post, I have mentioned that there is a possibility to have “seasonality” “Trend” and  errors (residual) in one dataset: Seasonality+Trend+Residual we call it as ...

## Identifying Number of Cluster in K-mean Algorithm in Power BI: Part 7

Posted on May 17, 2017

I have explained the main concept behind the Clustering algorithm in Post 5 and also I have explained how to do cluster analysis in Power BI in Part 6. In this post, I will explain how identify the best number of cluster for doing cluster analysis by looking on the “elbow chart” K-Mean clusters the data ...