Forum Discussion

SCNCKS1's avatar
SCNCKS1
Icon for Helper I rankHelper I
3 years ago
Solved

Previous Weeks Data with date slicer

Hi - I am creating a line chart that is supposed to show - screen shot of what my report looks like is below along with a table showing there should be at least 1 point green and orange.    - data f...
Need Help
  • SCNCKS1's avatar
    SCNCKS1
    3 years ago

    Hi Foodd - the powerbi file is attached to the SharePoint data, which is sensitive, i am not able to post the data online. 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

SCNCKS1 try this for prev week

 

Value Prev Week =
VAR __selectedWeekRank = SELECTEDVALUE ( 'Date'[Week Rank] )
VAR __prevWeekRank = __selectedWeekRank - 1
RETURN
    CALCULATE(
        [Value/DAY],
        'Date'[Week Rank] - __prevWeekRanke
    )

 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo