Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.LeanAndPractise(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
User | Count |
---|---|
57 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
41 | |
40 | |
28 | |
22 |