Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rolling 12 month based on master calenter selection

Hi All  I have dataset like below table Reference File : Rolling 12 month (.pbix)    Month Start Date # New Client # Chrun Client Type of Revenue 01-12-2018 2   Non Recurring 01-12...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    We have made it a cumulative  total, As there is no last month value.

    Cumm Last month (Starting Client )= CALCULATE(SUMX(Table,Table[# New Client]-Table[# Chrun Client]),filter(date,date[date] <=maxx(date,max(dateadd(date[date]),-1,month))))

    Cumm This Month (Ending Client )= CALCULATE(SUMX(Table,Table[# New Client]-Table[# Chrun Client]),filter(date,date[date] <=maxx(date,date[date])))

     

    Did not check pbix. Will do if this does not help

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous 

We have made it a cumulative  total, As there is no last month value.

Cumm Last month (Starting Client )= CALCULATE(SUMX(Table,Table[# New Client]-Table[# Chrun Client]),filter(date,date[date] <=maxx(date,max(dateadd(date[date]),-1,month))))

Cumm This Month (Ending Client )= CALCULATE(SUMX(Table,Table[# New Client]-Table[# Chrun Client]),filter(date,date[date] <=maxx(date,date[date])))

 

Did not check pbix. Will do if this does not help