Forum Discussion

jhollingworth's avatar
jhollingworth
Frequent Visitor
2 years ago
Solved

Help with counting when comparing to previous columns

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 ...
Need Help
  • jhollingworth's avatar
    jhollingworth
    Frequent Visitor
    2 years ago

    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!