Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
Can someone please help?
This is what I need (Ideally with the rolling showing accross a longer period but this is just a sample)-
YYYYMM | under 1hr | Total | In month % | Rolling 12 % |
012022 | 456 | 500 | 91.20% | |
022022 | 678 | 700 | 96.86% | |
032022 | 480 | 520 | 92.31% | |
042022 | 562 | 578 | 97.23% | |
052022 | 574 | 600 | 95.67% | |
062022 | 586 | 600 | 97.67% | |
072022 | 598 | 620 | 96.45% | |
082022 | 610 | 630 | 96.83% | |
092022 | 622 | 640 | 97.19% | |
102022 | 634 | 645 | 98.29% | |
112022 | 646 | 650 | 99.38% | |
122022 | 658 | 670 | 98.21% | 96.61% |
This is what I have -
Solved! Go to Solution.
Try this measure. The tables have a relationship on the date column. The visual uses DimDate[YYYYMM].
Rolling 12 Month % =
VAR vUnder1Hour =
CALCULATE (
SUM ( FactTable[under 1hr] ),
DATESINPERIOD ( DimDate[Date], MAX ( DimDate[Date] ), -12, MONTH )
)
VAR vTotal =
CALCULATE (
SUM ( FactTable[Total] ),
DATESINPERIOD ( DimDate[Date], MAX ( DimDate[Date] ), -12, MONTH )
)
VAR vResult =
DIVIDE ( vUnder1Hour, vTotal )
RETURN
vResult
Proud to be a Super User!
Try this measure. The tables have a relationship on the date column. The visual uses DimDate[YYYYMM].
Rolling 12 Month % =
VAR vUnder1Hour =
CALCULATE (
SUM ( FactTable[under 1hr] ),
DATESINPERIOD ( DimDate[Date], MAX ( DimDate[Date] ), -12, MONTH )
)
VAR vTotal =
CALCULATE (
SUM ( FactTable[Total] ),
DATESINPERIOD ( DimDate[Date], MAX ( DimDate[Date] ), -12, MONTH )
)
VAR vResult =
DIVIDE ( vUnder1Hour, vTotal )
RETURN
vResult
Proud to be a Super User!