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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
selpaqm
Helper V
Helper V

Find and expand value with another cell condition

CustomerWeek NoConditionWeek Result

A

12112
A10

0

12
A10012
A12012
B1109
B919

Hi all,

 

I want to create result column. it should be related with if condition section is 1 for a specific customer. please check example table and advise. thanks 

2 REPLIES 2
mahoneypat
Employee
Employee

Please try this expression in your calculated column to get your desired result.  Replace WeekResults with your actual table name.

 

Week Result New =
VAR __thiscustomer = WeekResults[Customer]
VAR __weekwith1condition =
    CALCULATE (
        MIN ( WeekResults[Week No] ),
        ALLEXCEPT ( WeekResults, WeekResults[Customer] ),
        WeekResults[Condition] = 1
    )
RETURN
    IF ( WeekResults[Condition] = 1, WeekResults[Week No], __weekwith1condition )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


nandu_krishna
Employee
Employee

@selpaqm 

 

Try this calculated column

 

Column =
VAR result =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Customer] = EARLIER ( 'Table'[Customer] )
                && 'Table'[Condition] = 1
        ),
        'Table'[Week No]
    )
RETURN
    result

 

 

output.PNG

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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