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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hackfifi
Helper V
Helper V

DAX Help to For Drawdown

Good Day
I am trying to calculate the "Drawdown" row as per the below data table example.
As you can see the TOTAL CUMATIVE Formula used gives the Cumulative by Year resulting in a value of $186
 
I am trying to Acheive the "DrawDown" calculation based on WIN(+) and NO WIN(-) by year
Hence starting from $186 (Total Budget) - "NO WIN" + "WIN" 

So in the below example:
=186-[5+0]-[25+0]-[15+0]-[5+16]-[15+10]-[30+0]-[25+15]-[15+10]
 
Hence, i need support to develop the above measure Cumulative Drawdown by Year
 
Thanks!
 
Total_Cumulative_Overall =
CALCULATE(
    [Budget],
    FILTER(
        ALLSELECTED('_Calendar'),
        ISONORAFTER(_Calendar[Date]MAX(_Calendar[Date]),DESC)
        )
)
 
PowerBi Query - Drawdown.JPG
1 ACCEPTED SOLUTION

I don't pretend to understand the definition of drawdown (despite having read the article multiple times) but here is a solution proposal.

 

 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

Will each P value always only be either Win or No Win? Will that not change over time?

 

Please provide sanitized sample data that fully covers your issue. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... I can only help you with meaningful sample data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.


@lbendlin  - The expected result is the "Drawdown" row below

IDWIN STATUS2017201820192020202120222023202420252026
P01NO WIN    $5$10    
P02NO WIN $5        
P03NO WIN    $5$5    
P04NO WIN $5        
P05NO WIN $2$2       
P06NO WIN $3$3       
P07NO WIN    $5$5    
P08NO WIN$5$5        
P09NO WIN $5$10       
P10NO WIN    $5$10    
P11NO WIN   $5      
P12WIN      $10$5  
P13NO WIN     $5$5   
P14WIN      $5$5  
P15NO WIN      $5$5  
P16WIN   $6$10     
P17NO WIN     $5$10   
P18WIN   $10      

 

NO WIN$5$25$15$5$20$40$20$5$0$0
WIN$0$0$0$16$10$0$15$10$0$0
           
           
TOTAL CUMULATIVE$5$30$45$66$96$136$171$186$186$186
DRAWDOWN$181$156$141$152$142$102$97$102$102$102




I don't pretend to understand the definition of drawdown (despite having read the article multiple times) but here is a solution proposal.

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.