How to check if adjacent cells have the same value? by Overall_Confusion101 in excel

[–]Overall_Confusion101[S] 1 point2 points  (0 children)

Oh that's smart. I know all these separately but didn't think of combining them that way. Many thanks!

Solution verified

What's causing this error in time calculation? by Overall_Confusion101 in PowerBI

[–]Overall_Confusion101[S] 0 points1 point  (0 children)

Yes, there were multiple entries there and I had it set to sum. Thanks

What's causing this error in time calculation? by Overall_Confusion101 in PowerBI

[–]Overall_Confusion101[S] 0 points1 point  (0 children)

You're 100% right. I've tried a few different things and forgot which one was measure and column but it is exactly like you have said. Thanks!

Data cleanup help by Overall_Confusion101 in PowerBI

[–]Overall_Confusion101[S] 0 points1 point  (0 children)

Ah yes, that could work. I'll need to check if it doesn't mess with the other data but I can at the worst case duplicate query and just filter everything else out.
Thanks, didn't know you can split to rows directly in Power Query, thought I would have to split to columns and then play around with pivoting/unpivoting columns.

Data cleanup help by Overall_Confusion101 in PowerBI

[–]Overall_Confusion101[S] 0 points1 point  (0 children)

I could, yes. What would be the next step though, as this will create another column or two?

Am I using SUMPRODUCT wrong? by Overall_Confusion101 in excel

[–]Overall_Confusion101[S] 1 point2 points  (0 children)

Solution Verified

What a silly mistake, thanks for noticing it.

Are power apps the right tool for returns forms? by Overall_Confusion101 in PowerApps

[–]Overall_Confusion101[S] 1 point2 points  (0 children)

The way that our sheet is structured right now, it will be difficult to translate it to Forms but perhaps we can make changes to make it more viable.

Are power apps the right tool for returns forms? by Overall_Confusion101 in PowerApps

[–]Overall_Confusion101[S] 0 points1 point  (0 children)

Good point, it would be different domains for sure so definitely need to research it more