Forum Discussion
HOw to use, IF, AND, Lookup, match, maybe all or none of these!
Good evening/morning, I could do with some help on the example workbook I have added. What I am trying to acheive is this:- Include all of the relevant invoice numbers from sheet 2, onto shee...
- Thanks Detlef Lewin, any chance of a video to show me how to set this up?
There is this thing called web search.
https://www.google.com/search?q=add+data+model+pivot+table
https://www.google.com/search?q=add+text+to+values+area+of+a+pivot+table
- Detlef_Lewin
Many thanks for this. I did turn to google in the first ance before my previous reply, and have looked at the 2 pages you have sent. As I am a complete rookie on pivot tables, I have struggled puttting it together like you have. I am able to make a pivot table, but need help getting the data from sheet 2, and really do not understand DAX measure. Are you able to provide a step by step guide at all please?
I am getting the error 'a table can''t overlap another table'
