Forum Discussion

getitout's avatar
getitout
Icon for Helper I rankHelper I
6 years ago

There will be 2 slices since we want to select pre dates (range) and post date range, which is not overlapped.

Thanks for the comment, this is my first post. Will try to write clearer.

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

I still do not understand.  I am willing to help if you take a clear example and show the exact expected result.

  • getitout's avatar
    getitout
    Icon for Helper I rankHelper I
    6 years ago

    Thanks for all the suggestion.

     

    I've got the solution from the community to use cross join

    Parameters =
    var periods = VALUES(data[startday])
    return CROSSJOIN(
    SELECTCOLUMNS(periods,"Pre", [startday]),
    SELECTCOLUMNS(periods,"Post", [startday])
    )
     
    Average KPI=
    var period1 = CALCULATE(
    AVERAGE(data[KPI]),
    TREATAS(VALUES(Parameters[Pre]),pm[starttime])
    )
    var period2 = CALCULATE(
    AVERAGE(data[KPI]),
    TREATAS(VALUES(Parameters[Post]),data[startday])
    )
     
    return IF(period2>period1, "PASS", "FAIL")

     

     
    I will your suggested method as well.
    Thank you very much.