or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

101 watchers
GlennR
GlennR
Feb 2019
2:51pm, 27 Feb 2019
41,130 posts
  •  
  • 0
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
Diogenes
Feb 2019
3:35pm, 27 Feb 2019
34,631 posts
  •  
  • 0
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
run free
Feb 2019
5:30pm, 27 Feb 2019
3,355 posts
  •  
  • 0
run free
Hey Curly - could create a Measure with the differences and then use SWITCH or IF in the measure
run free
run free
Feb 2019
5:30pm, 27 Feb 2019
3,356 posts
  •  
  • 0
run free
(BTW I am not sensible)
run free
run free
Feb 2019
5:32pm, 27 Feb 2019
3,357 posts
  •  
  • 0
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
Curly45
Feb 2019
7:03pm, 27 Feb 2019
3,858 posts
  •  
  • 0
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
run free
Feb 2019
8:53pm, 27 Feb 2019
3,358 posts
  •  
  • 0
run free
Defo - much nicer solution :)
GlennR
GlennR
Feb 2019
7:19pm, 28 Feb 2019
41,160 posts
  •  
  • 0
GlennR
I’ve been invited to attend a Tableau training course. There may trouble.
Curly45
Curly45
Feb 2019
7:25pm, 28 Feb 2019
3,859 posts
  •  
  • 0
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
run free
Feb 2019
10:26pm, 28 Feb 2019
3,360 posts
  •  
  • 0
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.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work








Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 113,967 Fetchies!
Already a Fetchie? Sign in here