Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Delta Between Two Dates Aggregation

In Power BI I have two tables. Holidays: Table_1 (My Main Table):   In Table_1 I created a measure.  This measure calculates the difference between two dates and excludes weekends and...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    Would you please try the measure below:

     

     

    measure =
AVERAGEX (
    SUMMARIZE ( 'Table_1', 'Table_1'[Opened], 'Table_1'[Closed], "_delta", [Delta] ),
    [_delta]
)

measure2 =
MEDIANX (
    SUMMARIZE ( 'Table_1', 'Table_1'[Opened], 'Table_1'[Closed], "_delta", [Delta] ),
    [_delta]
)

     

     

    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
Community Support
6 years ago

Hi Anonymous ,

 

Would you please try the measure below:

 

 

measure =
AVERAGEX (
    SUMMARIZE ( 'Table_1', 'Table_1'[Opened], 'Table_1'[Closed], "_delta", [Delta] ),
    [_delta]
)

measure2 =
MEDIANX (
    SUMMARIZE ( 'Table_1', 'Table_1'[Opened], 'Table_1'[Closed], "_delta", [Delta] ),
    [_delta]
)

 

 

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