Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Selected Week from Next 4 week value calculation .

I have table name called Invenoty sheet . this table look like . based on the  wknum selection will show rolling average to next 4 weeks .    (Wknum is text format)     DATE                   ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    You already have a Date table, it is better to use it. Please refer to attached file with the proposed solution

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
If [wknum] column is from the 'Date' table then it should work with a small modification

Mesaure =
CALCULATE (
    SUM ( Append1[Value] ),
    Append1[Attributes] = "Demand",
    DATESINPERIOD ( 'Date'[Date], MIN ( 'Date'[Date] ), 1, MONTH ),
    ALLSELECTED ( Append1 )
)

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    tamerj1   Not a column from Date. it is a text column(weeknum) in the table.

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Hi Anonymous 
      Please try

      Mesaure =
VAR CurrentDate =
    CALCULATE (
        MIN ( 'Date'[Date] ),
        CROSSFILTER ( 'Date'[Date], Append1[Date], BOTH )
    )
RETURN
    CALCULATE (
        SUM ( Append1[Value] ),
        Append1[Attributes] = "Demand",
        DATESINPERIOD ( 'Date'[Date], CurrentDate, 1, MONTH ),
        ALL ( Append1 )
    )
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        tamerj1  i have tired above measure .. but i am getting  CROSSFILTER function can only use the two column references participating in a relationship.