Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
szielinski
Frequent Visitor

Cumulative Sum and Rest between 2 dates

i Dont know if is possible to do this but i have this matter that i want to reach i need to know how many of a flag # where "active" by Day, i have 3 columns of info 

szielinski_0-1629228747057.png

my goal is to know fo explample how many was open the day 01/01/21, the reference is : all them that where add on bebefore 01/01/21 less the ones that was also removed before that date are the ones "actives",  i need to use both add and remove dates on for make it work, and plus have a calendar relationship between those 2 for help me to show that calculation on a time like, i've triying everything but nothing looks to work here some example 

 

combination = IF('AccountFlagsAll'[impound] = 1, +1 , IF('AccountFlagsAll'[Added On] <> 'AccountFlagsAll'[Added On],+1,IF('AccountFlagsAll'[Removed On] = ' AccountFlagsAll'[Added On],-1,0)))
1 REPLY 1
Greg_Deckler
Super User
Super User

@szielinski 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.