dax error

Hi fellow Excel users and fans, Huge problem here that is freaking annoying. Hope you guys can help. I've built a beautiful Excel with: 1. PowerQuery to bring in Data; 2. PowerPivot to link them together. For step 1, I refresh the queries just fine. But for step 2, when click Refresh All in...

Hello. I was recently upgraded from Excel 2013 to Excel 2016. I have a Power Pivot file that works fine in 2013, but when I try to open it in 2016 I get errors in several calculated columns. The calculated columns are simple (measure 1 + measure 2 + measure 3) so it doesn't seem to be a syntax...

Hi all! I'm desperately trying to get PowerPivot to count the number of 'L's in a column. L itself is a measure, which returns 'L' for stores which have not bought in over a year (and are therefore Lost) and blank for all other cases. When I try the following function...

Hi I am having issues with measures that were built in Powerpivot 32bit. The measures are in the form: Booking_2012:=calculate('vXXXX'[Sum of Bookings],'vXXXX'[Year]="2012") with vXXXX the tab name. I have reopened on the 32bit machine and measures are still valid, but have the following...

Hello, I bought Bill's book and trying to follow instructions given on page 25 and 26 but I get error message "the end of the input was reached" can anyone help?? exact error message:- ============================ Error Message: ============================ The end of the input was...