Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Here is a small dataset sample. I have a single table and no connecting relationships.
Run Date | Order # | On ATP | Order on ATP |
8/9/2023 | 1 | TRUE | TRUE |
8/9/2023 | 1 | TRUE | TRUE |
8/9/2023 | 1 | TRUE | TRUE |
8/9/2023 | 2 | FALSE | FALSE |
8/9/2023 | 2 | TRUE | FALSE |
8/9/2023 | 2 | FALSE | FALSE |
8/10/2023 | 1 | TRUE | TRUE |
8/10/2023 | 1 | TRUE | TRUE |
8/10/2023 | 1 | TRUE | TRUE |
8/10/2023 | 2 | FALSE | FALSE |
8/10/2023 | 2 | TRUE | FALSE |
8/10/2023 | 2 | FALSE | FALSE |
8/11/2023 | 1 | TRUE | TRUE |
8/11/2023 | 1 | TRUE | TRUE |
Each day, I need to determine if the entire order is on ATP or not. The desired result is the last column. As you can see, not all order lines are on ATP. I need a column or measure that returns a TRUE statement if the all lines on the order for that day are TRUE for On ATP.
Hope that makes sense.
Thanks,
Solved! Go to Solution.
Simple enough,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Thank you! I was using EARLIER on run date, but not on order #.
Hi @jwin2424
please try
Order on ATP =
VAR CurrentOrderATPs =
CALCULATETABLE (
VALUES ( 'Table'[On ATP] ),
ALLEXCEPT ( 'Table', 'Table'[Run Date], 'Table'[Order #] )
)
RETURN
IF ( COUNTROWS ( CurrentOrderATPs ) = 1, CurrentOrderATPs, FALSE )
As a side note, this worked as well. Thank you
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |