I have table name called Invenoty sheet . this table look like . based on the wknum selection will show rolling average to next 4 weeks .
DATE ATTRIBUTE wknum value
15 March 2021 Demand wk01 45
22 March 2021 Demand wk02 55
29 March 2021 Demand wk03 65
05 April 2021 Demand wk04 45
12 April 2021 Demand wk05 95
19 April 2021 Demand wk06 25
26 April 2021 Demand wk07 35
I am Used below Measure
Expected Output :
wknum ATTRIBUTE value Selected week from Next 4 week
wk01 Demand 45 220 => 55+55+65+45
wk02 Demand 55 260 => 55+65+45+95
wk03 Demand 65 250 => 65+45+95+45
wk04 Demand 45 240 =>45+95+45+55
wk05 Demand 95 195 =>95+45+55
wk06 Demand 45 90 =>45+55
wk07 Demand 55 55 =>55
Looking for support .. thanks in advance .
Solved! Go to Solution.
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 ) )
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 ) )
@tamerj1 i have tired above measure .. but i am getting CROSSFILTER function can only use the two column references participating in a relationship.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.