Facing issue while creating a column in power bi

Hi Anonymous ,

 

Try to modify your formula like below:

Last Used =
IF (
    'Power Automate Flow Inventory'[Duration] < 30,
    "Less than 30 Days",
    IF (
        'Power Automate Flow Inventory'[Duration] >= 30
            && 'Power Automate Flow Inventory'[Duration] < 60,
        "Over 30 Days",
        IF (
            'Power Automate Flow Inventory'[Duration] >= 60
                && 'Power Automate Flow Inventory'[Duration] < 90,
            "Over 60 Days",
            IF (
                'Power Automate Flow Inventory'[Duration] >= 90
                    && 'Power Automate Flow Inventory'[Duration] < 180,
                "Over 90 Days",
                IF ( 'Power Automate Flow Inventory'[Duration] >= 180, "Over 180 Days" )
            )
        )
    )
)

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.