As recommended in another post, I converted my macros into a table-based Excel which includes queries. I am now facing a issue that I hope somebody can help with.
I am trying to create a table that has both columns and rows dynamically updated. I managed to do this, but the content of...
I have a question regarding some DAX functions,
What exactly does
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
mean? I presume the function has to be nested...
Can you please help me find a solution to the below issue? I tried Vlookup, but it is really time-consuming.
I have two sheets. One with the contact details and one with the product details. I want them to map it based on the account data.
Result required ...
Hello All, I am working on a project and I want to know which one supports a query editor between Power Bi and Tableau? According to a source, Tableau does not support this feature may be and I have no idea about power bi? Can anyone explain to me who supports query editor?
Long story short, I managed to push data from "public" websites. Quite straight forward process Data > Get External Data > Run Web Query and I get the data I want.
My problem is how to do this if the data I need to access is personalized for a single user. I do have access to login details and...
Since I see update speed benefit in it, I typically use Table.Buffer in all of my queries by wrapping the very last line.
Source = #"My Data"
Table.Buffer(Source) as table
However, when someone else uses the same template file on their machines, the queries won't refresh...
How can I rename a query (not its shortcut)?
I've a query that is part of a 'Group' under 'Custom' category in Navigation pane. When I right click on the query I see option of renaming the shortcut. How can I rename the actual query (not only the shortcut)?
I am using MS Access2016...
I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one.
In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...
I use a dynamic table which absorbs data from a query regarding the name of sales agents, names and codes of (their) clients, and hours left from a pack. It can be updated to reflect the new amount of hours left, and I can filter by name of salesperson to show only their clients and the...
Hello All, I am completely new to access and was trying to do this with Excel Power query and was successful however the data is so large that it is taking forever to run, so I decided to give access a go. Here is the situation, I have 10 locations I manage and each day I receive a csv file for...
This has probably been posted but I have been looking for it confused for quite some time. I'm quite new to access - have written a few queries but am looking for a solution which doesn't seem to fit anything I have found as yet.
I have a database with linked tables with 1 to many...
Hi There i am new to using MS Query, i think this should be a very simple answer.
I am looking to display all of the order numbers that are beginning with W, but do not include those with a '/' in the order number.
I started by doing Like 'W%' which works for the first part. How do i then edit...
I have a large excel file with over 50 columns that is out of order when i downloaded from web. So web content management system scrambled all the columns, and when export to excel, all columns are out of order. Original data is a Form responses that exported out to excel...
I would like to solve this problem using formula, query, or pivot.
My company is issuing invoices. Most of them charge audit service fee and outlay together, and a few of them only charge outlay.
I cannot think of a logic to distinguish them in the format I expected.
I am using the query function with 3 different ranges within 1 formula, Where i want to Select a column if Column X = to a 'Name'.
The problem i am facing currently is that the first 2 Ranges are give me back 2 Null values since it cannot find the name and the 3rd range contains the name.
I am stumped.
I am trying to merge two tables into a new table using a LEFT JOIN. Both tables have unique records on each row. When I join the tables, BI creates duplicate rows on some records for no apparent reason. The duplicates are identical in every way.
I followed the steps...
#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated)
how to possible get data as a list format,
NOTE: SHEET 1 :
*** So many Space in there***
@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ????
I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference
Hi All, I am using Mac and my team is using windows majorly. We have excel where windows user are able to see the data without any issue but i am getting #REF! in most of the cells.
Weirdly , when i opened another excel which is connecting to DB and getting the data and then opened the above...