+ Reply to Thread
Results 1 to 1 of 1

DAX Formulas Advice Needed for YoY Growth/Sell-through etc

  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Vancouver, Canada
    MS-Off Ver
    Ofice 2013
    Posts
    26

    DAX Formulas Advice Needed for YoY Growth/Sell-through etc

    Hello!

    Not sure if this is the right thread for this topic so if it's not please let me know .

    I have started to use Power Query/Power Pivot and because of that I need to start to use DAX expressions and formulas. I work for a retailer and need to just need to start with some basic calculations like Year over year sales growth or decline.

    However, using DAX expressions to build calculated formulas in my power pivot tables has really stumped me and I've hit a road block. In original pivot tables, the formulas are very easy as can just work with the fields in the data table but DAX expressions are stumping me.

    In our business, we work in week chunks and that is how the data is posted. For example, week 1/2019 is shown as --> 1.2019. So the sales or store inventory data is not shown by a specific date (ex. 01/01/2019). Most of the online help in articles/youtube videos etc has shown this same situation but it almost always refers to data that is in the date format of specific days and not weeks the way my company provides the date. A general question, can I still build a DAX expression for YoY growth if our timelines are shown like this?


    I've attached an example of the data source that I am using, it's only a few lines but you can see generally how the data source is laid out. I've also attached screen shots of my power query and the power pivot tables that I've created.


    Thank a lot for your help!
    Attached Images Attached Images
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 11-24-2015, 11:32 AM
  2. Help needed Please on Excel Formula for Growth
    By shadow81 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-24-2014, 07:39 PM
  3. Trend? Growth? Mathematic approach needed.
    By Jimbras in forum Excel General
    Replies: 4
    Last Post: 05-25-2009, 11:54 AM
  4. help advice needed
    By stevencarroll19 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-30-2006, 12:00 PM
  5. [SOLVED] Advice needed on clearing cells without removing formulas
    By Digital2k in forum Excel General
    Replies: 12
    Last Post: 07-02-2006, 05:55 PM
  6. [SOLVED] advice needed
    By Duncan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2005, 07:06 PM
  7. [SOLVED] Advice needed...
    By Duncan in forum Excel General
    Replies: 3
    Last Post: 01-27-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1