Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cummulative Trending View

Hi,   I wanted calculate a cummulative view. My table looks like below, Loan ID Date Status 1 2-Jan Contracted 1 3-Jan PTD 2 4-Jan Contracted 3 5-Jan Contracted 4 1-F...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Sir,

 

This works fine when it is applied to this smaller dataset. but when i apply it to my larger dataset (which is something similar with lot more statuses), the measure 2 and 3 which you have calculated comes to be empty. Please give me any leads where it would have gone wrong.

 

Thanks,

Dharani

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

If it working on a small dataset, it should also work on a large one.  I cannot guess the mistake which you are commiting.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thank you so much Sir!!

         

        One final question,

        In your last measure,

         

        Measure 2 = SUMX(CALCULATETABLE(VALUES(Data[PAT_ID]), DATESBETWEEN('Calendar'[Date], MINX(ALL('Calendar'), 'Calendar'[Date]), MAX('Calendar'[Date]))),[Measure 3])
         
        How do i add an another condition,
        that i have to sumx the values of pat_id, only if a column called "flag" is 1.