Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have simple table with 3 columns
Index - every month from now back is +1
Datum
OEE - calculated measure
Calendar_StartDT - basically shift (6:00,14:00,22:00)
I want to show average of OEE in chart of last 4 months back but I cant find how.
OEE is measure calculated per shift and if I put it on chart its ok if I have date on X but when I put there MonthIndex it probably SUM those values
Any idea how to get this average per index (month) ? Thank you!
Topic closed
problem was in my variable VAR _plannedProd where I didnt add days so when I filteres data I still had data only for one day
to make it bit more clear, here is how I calculate OEE
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |