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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
evadung
Frequent Visitor

Moving average excluding days without data

Hello, 

 

I have this chart with moving average. I dont want to see 4th and 5th day because theres no data (theres more date without data, 4th and 5th is for example). I have no clue what to do.

evadung_1-1676360046697.png

 

Its from calculated measure from two tables:

 

Table1: date, hours1
Table2: date, hours2

(In those tables arent days with null or blank spaces.)

 

calculated measure: Produtivität = hours1/hours2

 

Moving average % =

averagex(
    FILTER(ALLSELECTED(Kalender),
    Kalender[Datum] <= MAX(Kalender[Datum])),
        [Produktivität])
 
1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

Moving average % =IF( [Produktivität],

averagex(
    FILTER(ALLSELECTED(Kalender),
    Kalender[Datum] <= MAX(Kalender[Datum])),
        [Produktivität]))

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User
Super User

Moving average % =IF( [Produktivität],

averagex(
    FILTER(ALLSELECTED(Kalender),
    Kalender[Datum] <= MAX(Kalender[Datum])),
        [Produktivität]))

Works! Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors