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 
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.

 

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Anonymous 
    Which columns are invloved in the relationship? Is there even a relationship between the two tables?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      tamerj1  that issues has  been fixed but  sum values are  showing  different . I have attached Power bi file for your reference sir 

       

      Power bi File  

      • tamerj1's avatar
        tamerj1
        Community Champion
        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