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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Need Help

Hi All,

 

I have a data set like below.  the last cilumn Strategy_Approval_status needs to be populated . The logic is if strategy_name has Approved in Task_name_approval_status then that Strategy is Approved, If it does not have approved and has only 'Awaiting approval' Then it is 'awaiting approval', and  if the sttaus is 'Not Approved ' then it will be Not Approved. I have populated the columns accordingly.   It is not possible to do a if condition on Strategy_Name as there are numerous values of it. 

 

Is it possible to calculate Strategy_Approval_Status then? Please help

 

Strategy_Name  Task_Name Task_Approval_Status Date_Created USD_Value Strategy_Approval_Status(needs to be calculated)

STR1                    Stage1        Awaiting Approval                             100            Approved

STR1                    Stage2        Awaiting Approval                             100            

STR1                    Stage3        Approved                                           100

STR2                    Stage1        Awaiitng Approval                             200           Awating Approval

STR2                    Stage2        Awaiting Approval                             200

STR3                    Stage 0       Not Approved                                    600          Not Approved

STR4                    Stage2        Awaiting Approval                              400          Approved

STR4                    Stage3        Approved                                            400

 

Thanks in advance!!

 

Regards

Ankhi

1 ACCEPTED SOLUTION
rajulshah
Resident Rockstar
Resident Rockstar

Hello @Anonymous,

 

Please use the following DAX and let me know if this is what you want:

Latest Stage = 
VAR LatestStage = ADDCOLUMNS(Strategy,"RankbyStage",COUNTX(FILTER(ALL(Strategy),Strategy[Strategy_Name] = EARLIER(Strategy[Strategy_Name]) && Strategy[Task_Name]< EARLIER(Strategy[Task_Name])),Strategy[Strategy_Name])+1)
VAR MaxValue = MAXX(FILTER(LatestStage,[Strategy_Name]=EARLIER([Strategy_Name])),[RankbyStage])
RETURN MINX(FILTER(LatestStage,[RankbyStage]=MaxValue && Strategy[Strategy_Name]=EARLIER(Strategy[Strategy_Name])),Strategy[Task_Approval_Status])

 

Hope this helps. 

View solution in original post

2 REPLIES 2
rajulshah
Resident Rockstar
Resident Rockstar

Hello @Anonymous,

 

Please use the following DAX and let me know if this is what you want:

Latest Stage = 
VAR LatestStage = ADDCOLUMNS(Strategy,"RankbyStage",COUNTX(FILTER(ALL(Strategy),Strategy[Strategy_Name] = EARLIER(Strategy[Strategy_Name]) && Strategy[Task_Name]< EARLIER(Strategy[Task_Name])),Strategy[Strategy_Name])+1)
VAR MaxValue = MAXX(FILTER(LatestStage,[Strategy_Name]=EARLIER([Strategy_Name])),[RankbyStage])
RETURN MINX(FILTER(LatestStage,[RankbyStage]=MaxValue && Strategy[Strategy_Name]=EARLIER(Strategy[Strategy_Name])),Strategy[Task_Approval_Status])

 

Hope this helps. 

Anonymous
Not applicable

Thank you so so much..

 

It worked !!!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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