for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

GlennR Feb 2019 2:51pm, 27 Feb 2019 41,130 posts	Quote Pin GlennR Great work of fiction though sometimes. Curly, I was hoping that someone sensible would answer your question. What sort of formula are you thinking of? Isn't it possible to put a filter into the Pivot setup that would do the same as the formula?
Diogenes Feb 2019 3:35pm, 27 Feb 2019 34,631 posts	Quote Pin Diogenes I like planning, it's much easier and more fun than actually doing something. it's when you start the doing that it all starts going wrong. A successful project is one that is abandoned before it's begun* *see also "so many moonlight kisses"
run free Feb 2019 5:30pm, 27 Feb 2019 3,355 posts	Quote Pin run free Hey Curly - could create a Measure with the differences and then use SWITCH or IF in the measure
run free Feb 2019 5:30pm, 27 Feb 2019 3,356 posts	Quote Pin run free (BTW I am not sensible)
run free Feb 2019 5:32pm, 27 Feb 2019 3,357 posts	Quote Pin run free Sorry for all the responses. Am trying to do multiple tasks at the same time.....Curly the DAX IF function will work like an EXCEL IF. If you have multiple case statements then use SWITCH. Am hoping this all makes sense.
Curly45 Feb 2019 7:03pm, 27 Feb 2019 3,858 posts	Quote Pin Curly45 Thanks R F. Hadn't thought of doing it in DAX duh! Can calculate inside the model and display on the excel sheet view. Nice.
run free Feb 2019 8:53pm, 27 Feb 2019 3,358 posts	Quote Pin run free Defo - much nicer solution
GlennR Feb 2019 7:19pm, 28 Feb 2019 41,160 posts	Quote Pin GlennR I’ve been invited to attend a Tableau training course. There may trouble.
Curly45 Feb 2019 7:25pm, 28 Feb 2019 3,859 posts	Quote Pin Curly45 I like it, but it depends on the inputs being set up properly. Don't believe the hype about it solving all your data problems is all I will say.
run free Feb 2019 10:26pm, 28 Feb 2019 3,360 posts	Quote Pin run free Tableau? That's cos Academia gets it free.....But it is darn expensive to companies. Power Pivot + all the other Power tools do just as good a job and are built into Excel.