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
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.
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Does this work?

    Measure 2 = SUMX(CALCULATETABLE(VALUES(Data[PAT_ID]), DATESBETWEEN('Calendar'[Date], MINX(ALL('Calendar'), 'Calendar'[Date]), MAX('Calendar'[Date])),data[Flag]=1),[Measure 3])

    Ensure that the entries in the Flag column are of the Number data type.