Forum Discussion

MightyMicrobe's avatar
MightyMicrobe
Helper II
6 years ago

Measure for Previous Week Based on Index

Hi all, I have a table with a numeric index indicating Weeks Back from today.      I need to create a measure indicating the value of the previous week, based on the index.  I can successfully do...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    So typically you do this using ADDCOLUMNS like:

     

    Measure = 

    VAR __Table = ADDCOLUMNS('Table',"Previous",<your column formula goes here>)

    RETURN

    <some operation across __Table>

     

    If that is not enough detail for you. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.