Forum Discussion
percent change
Anonymous wrote:
Well, I have your book and I was looking through it too fast obviously before I closed it and posted here. I feel like an idiot now because your solution is pretty simple. Thanks!!
I know one thing, I need to start at page one and read it instead of trying to skim it.
Exactly! And in fact if you read the first couple of pages, I explicity state "If you think you read this book and not do the exercises and still get value, let me tell you - you can't". :-)You need to go slower (and do some learning) so you can go faster :-)
I know one thing, I need to start at page one and read it instead of trying to skim it.
Community Champion
Anonymous wrote:
Well, I have your book and I was looking through it too fast obviously before I closed it and posted here. I feel like an idiot now because your solution is pretty simple. Thanks!!
I know one thing, I need to start at page one and read it instead of trying to skim it.
Exactly! And in fact if you read the first couple of pages, I explicity state "If you think you read this book and not do the exercises and still get value, let me tell you - you can't". :-)
You need to go slower (and do some learning) so you can go faster :-)
I'm on page 18. :)
I have a little bit different issue. I need to add percent change of Employee Amount by Year to this Matrix and have it work with my slicer. I have tried several of the solutions I found online, but none seem to work for me. Can you help..Microsoft MVP Matt?
- MattAllington
I can't help you with specifics with the information you have provided. All DAX formulas depend on the table structure and you haven't provided that information. But I can tell you how to go about it.
Break the problem into steps.
The first step is to write a DAX formula that will give the result from Last Year. ie 2013 number will appear against the year 2014.
Then the percent is easy.
Read my article about time intelligence in DAX and it will help you
