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

    AntrikshSharma  Can you try please uploading the modified file one more time? I am not able to see any changes to the file I uploaded.

     

    Thanks again for your help.

     

    George Ponnatt

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        AntrikshSharma  Unfortunately the calculation below is wrong. It is not a straigtforward SUM()

        For example: During Jan 2020, the followings Opps are in Stage 1 : OP1, OP2, OP4, OP5,OP6

        Take OP1; it entered Stage1 Date on 12/15/2019. But it continues in that Stage till 2/10/2020, till it enters Stage2. So OP1 is in Stage1 on Jan 2020.

         

        So Stage 1 - Jan would be 900.  And Stage 3 -Jan should be 250. In Jan, only OP4 was in Stage 3.

        ie.. Stage dates show what date the opportunity entered a stage, and it remains in that stage till it enters Next stage.

         

        Appreciate the attempt.