the value of the average between the three periods

[Lexey]

Hi friends!
There is a fact table with the result of product sales by date. It is necessary to get the average value
between the three periods is selected in the slicers.

I will be glad of any help!

https://drive.google.com/open?id=1HShO0E5ueQcIy-MMqxdlmi4DHOcFkz0_

[Vvelarde]

@Lexey

The only that imagine is duplicate your Fact Table many times of slicers you want.

[Vvelarde · Accepted solution]

@Lexey

Using this model:

And a Measure Like This:

Measure =
VAR TotalTA =
    CALCULATE (
        SUM ( '1'[sales] );
        TREATAS ( VALUES ( 'Dates1'[Date] ); '1'[date] );
        ALL ( '1' )
    )
VAR TotalTB =
    CALCULATE (
        SUM ( '1'[sales] );
        TREATAS ( VALUES ( 'Dates2'[Date] ); '1'[date] );
        ALL ( '1' )
    )
VAR TotalTC =
    CALCULATE (
        SUM ( '1'[sales] );
        TREATAS ( VALUES ( 'Dates3'[Date] ); '1'[date] );
        ALL ( '1' )
    )
RETURN
    DIVIDE ( TotalTA + TotalTB + TotalTC; 3 )

Regards

Victor

[Lexey]

super! Thank you! Now I'm one step closer to the solution!

Only I need an average for each product, I'll try to find a solution)

[Lexey]

really? no solution to find the average for each product?