Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need Help with DAX expression - Opportunity Pipeline - Point in Time

Hi I am new to PowerBI. Stuck and need help!!   We have Opportunities pipeline data in the following format Opportunity GrossBooking Stage1Date Stage2Date Stage3Date CurrentStage OP1 ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak  Thanks for the reference. Based on your reference I was able to create a DAX expression like below which worked. Thanks a bunch for your help.. 

     

    I should have joined this community sooner.

     

    Stage1 = CALCULATE
    (
    SUMX(
    FILTER
    (Opportunities,
    Opportunities[Stage1Date] <= MAX('Calendar'[Date]) &&
    (ISBLANK(Opportunities[Stage2Date])
    || (Opportunities[Stage2Date] > Max('Calendar'[Date]))
    || (
    Opportunities[Stage2Date] >= Min('Calendar'[Date]) &&
    Opportunities[Stage2Date] <= max('Calendar'[Date])
    )
    )
    ),Opportunities[GrossBooking]
    ),CROSSFILTER(Opportunities[Stage1Date],'Calendar'[Date],None)
    )