cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

Calculated Column - True False based on Order value

Hello Community  -  I know this should be easy, but...

I have an orders table out of our ERP system.   I need to create a "flag" that allows the user to have a slicer with the two options:  Over \$75k, or Equal/Less \$75k.

In other words, imagine you have the orders table, and you quickly want to filter down to all Orders with a total value over 75,000 dollars...or....select all orders with a value below 75,000.

And the key is that this should be at the Order level  (not at the line level).

Thanks for any help!

1 ACCEPTED SOLUTION
Solution Sage

@Anonymous

This formula should work:

OVER 75K = IF('Table'[Order Value]>75000,"True","False")

Or you can use this formula:
OVER 75K = 'Table'[Order Value]>75000

If I answered your question, please mark it as a solution to help other members find it more quickly.

3 REPLIES 3
Anonymous
Not applicable

@jppv20    Sure!

Order Number   Order Value  OVER 75K

A-124                   78,909           TRUE

A-326                   67,098           FALSE

C-568                   75,004           TRUE

Solution Sage

@Anonymous

This formula should work:

OVER 75K = IF('Table'[Order Value]>75000,"True","False")

Or you can use this formula:
OVER 75K = 'Table'[Order Value]>75000

If I answered your question, please mark it as a solution to help other members find it more quickly.

Solution Sage

Hi @Anonymous ,

Can you provide some example data and expected output?

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors