Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey everyone,
I have a table with thosuands of parts that are received into our system.
Let's say Column A is the ItemID which is the part number and Column B is the Date that was received.
My goal is to check if a given part has entered into our system more than 5 times in a given 180 days period. So, at this point, I made something that works but it only checks for the last 180 days from today. I want to build something that can check for any 180 days for 5 batches received.
So, let's say if one part was received for 5 times between Jan 1st and July 1st for 5 times back in 2020, I want to flag that part.
Here is my current code with the 180 days from today thing.
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [CREATEDDATETIME] > DateTime.LocalNow() - #duration(180, 0, 0, 0)),
#"Grouped Rows" = Table.Group(#"Filtered Rows1", {"ItemId", "ItemName"}, {{"Count", each Table.RowCount(_), Int64.Type}}),
#"Filtered Rows2" = Table.SelectRows(#"Grouped Rows", each [Count] >= 5)
Solved! Go to Solution.
@power2 I would think something like this:
@power2 So, I would create a Parameter and then replace DateTime.LocalNow() with the name of that Parameter.
@Greg_Deckler
Thanks for the advise. In this case, how would that parameter look like? Can you be a little more specific?
@power2 I would think something like this:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |