Report Portal

DAX : Building a monthly salesreport with estimation in PowerPivot

In this blogpost I would like to take you with me when building report in PowePivot with DAX expressions in a couple of steps.  For my current customer I've to build a report that calculates the daily sales and they want to compare this with their target:

  • Monthly sales. How much have we sold of this product, per company, etc.
  • Extrapolation of monthly sales (estimation) and compare this with the target.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.