Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Static Average By Creating Bicket start from 01/07/2020

Hello Experts,   I have below input data:   DateKey            LocationID       MeasureValue 01-07-2020       100                   4000 02-07-2020       100                   6000 03-07-2020 ...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    Just a little modification on HotChilli's reply(Measure value seems not to be column in table):

     

    AVERAGEVALUE =
AVERAGEX (
    FILTER (
        ALL ( Table ),
        Table[Bucket] = MIN ( Table[Bucket] )
            && Table[LocationID] = MIN ( Table[LocationId] )
    ),
    [Measure]
)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

     

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Just a little modification on HotChilli's reply(Measure value seems not to be column in table):

 

AVERAGEVALUE =
AVERAGEX (
    FILTER (
        ALL ( Table ),
        Table[Bucket] = MIN ( Table[Bucket] )
            && Table[LocationID] = MIN ( Table[LocationId] )
    ),
    [Measure]
)

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai