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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors