Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
as a newbie my situation looks quiet simple, but I am fully stuck. Tthere is a table with a userdefined column containing a duration:
IntervalPlus = [MyTime]+ #duration(0,0,60,0)
With this column I want to create a kind of predictive graph with a measure:
Measure =
CALCULATE (
SUM(ExData[MyValue]),
FILTER('ExData', ExData[MyTime] <= ExData[IntervalPlus]),
FILTER('ExData', ExData[MyTime] >= ExData[MyTime])
)
Solved! Go to Solution.
or directly like:
Yes of yourse.
I have a table with two columns: Time and a value witch contains an amount of events per 5 minute interval.
For each 5 Minute Interval I want to create a new Datapoint containing the next 12 Rows in Sum, to get a real one hour SUM.
Example in Excel Screenshots for 3 instead of 12 Rows:
My try was to create a new column IntervalPlus with Time plus one hour (in this example 10 Minutes) and wanted to filter values where time is lower then IntervalPlus
hi @FrankW
try like:
or directly like:
Well, this works great, thank you very much. It is not easy for me to get into this, as it is more or less a side quest. Thanks a lot
hi @FrankW
could you tell us more about your expectation the measure, like what do you mean by "predictive graph"?
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |