Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

multiple multiplication with get avg value show it next month

 i have table column based  on value its split weekly date .

 

WEEK = var a = DATE(2020,08,03)
var b = IF(DatePA[Week Date] = a,"Outbound GLOBAL",IF(DatePA[Week Date]<>BLANK(),"Outbound" & DatePA[Week Date]))
return b
 
 
Uptime : 
 
Date = EOMONTH(MAX('DatePA'[Week Date]),-1)
 
Measure = EOMONTH([Date],-3)
 
 
Up time =
CALCULATE (
DIVIDE ( [calc op per day], [calc op per day manne] ),
FILTER (
'PA - E2PR',
AND (
'PA - E2PR'[Effective Date] < [Date],
'PA - E2PR'[Effective Date] >= Measuress[Measure]
)
 
)
)
 
 
Uptime Next:
 
Datenxt = EOMONTH(MAX(DatePA[Week Date]),0)
 
Measurenxt = EOMONTH([Datenxt],12)
 
Up time next =
CALCULATE (
DIVIDE ( [calc op per day], [calc op per day manne] ),
FILTER (
'PA - E2PR',
AND (
'PA - E2PR'[Effective Date] > [Datenxt],
'PA - E2PR'[Effective Date] <= Measuress[Measurenxt]
)
)
)
 
i have two value splitted uptime and uptime next .
 
Uptime  have previous three month value .
 
its multiple by constant three value 
 
Ex:
if i select  april  the value like 
Jan * 0.5  
Feb *0.3
March *0.2 
 
this avg value should be show may june july  same after that   Aug,sep,oct it  will increase by 1 .
please refere excel sheet screen shot reference 
 
THENNA_41_0-1630902479527.png

 

 

i have tired  create mesure but not working.  thanks in advance 

1 REPLY 1
lbendlin
Super User
Super User

@Anonymous Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.