Forum Discussion
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 ...
Anonymous , refer if this can help
AntrikshSharma
Community Champion
Community ChampionCan you define the lower boundaries and upper boundaries of each stages, maybe that could help, worth trying.
AntrikshSharma Stage boundaries of each opportunity is implied within the above opportunity data itself. Each opportunity starts at Stage1, then moves on to Stage 2 and so on.
Ex:
OP1 (Current Stage is Stage2)
Stage1 12/15/2019 - 2/9/2020
Stage2 2/10/2020 - Current
OP2 (Current Stage isStage1)
Stage1 12/1/2019 - Current
OP3 (Current stage is Stage3)
Stage1 2/1/2020 - 3/14/2020
Stage2 3/15/2020 - 6/1/2020
Stage3 6/1/2020 - Current