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.
Hello,
I'm hoping this is simple, but I can't seem to figure it out.
I have a sheet of data that has the number on hand of items based on dates:
Date | Items | Count Sum |
4/18/2024 | Bike | 5 |
4/18/2024 | Car | -1 |
4/18/2024 | Motorcycle | -3 |
4/10/2024 | Bike | -1 |
4/10/2024 | Car | 1 |
4/10/2024 | Motorcycle | 2 |
4/1/2024 | Bike | 5 |
4/1/2024 | Car | 2 |
4/1/2024 | Motorcycle | -2 |
I'm trying to make a Matrix in Desktop that compares the Count Sum of one date to the previous and tells me if it switched from Positive to Negative or Negative to Positive:
Type | 4/1/2024 | 4/10/2024 | 4/18/2024 |
Total Positive | 1 | 2 | 1 |
Total Negative | 2 | 1 | 2 |
Positive to Negative | n/a | 1 | 2 |
Negative to Positive | n/a | 1 | 1 |
I have the Total Positive and Total Negative working for each date but I am having trouble figuring out a formula the will evaluate each item to see if it went from positive to negative and then negative to positive.
This is as close as I have gotten:
Solved! Go to Solution.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Hi ThxAlot,
This worked! Thank you for the help.
I do have a question about the measure you created [SUM Count Sum]. Why can't you use "SUM('Data'[Count Sum])" instead? I tried this and it didn't work, but when I created a measure like you did, it did work.
Thank you!
I don't see two negatives for 4/1/2024
Please clarify.
That was an error from me changing data to make a better example of different scenerios. ThxAlot answer it though.
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 |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |