Hello, I have a table of data that has two columns: ‘Week Number’ and ‘Rolling 4 Week Total’. I’ve made a simple example below. I don’t have data for weeks before - starting value for Week 1 is unkn...
I am using Qualys's API documentation to pull their endpoints into Power Query. Doing the below works fine: let
Url = "https://qualysapi.qualys.eu/api/2.0/fo/knowledge_base/vuln/",
Auth...
I have a function to calculate elapsed business days between two dates: It works but if there is no EndDate, it returns an empty cell, I would like it to use "today" if there is no EndDate. ...
Hi all, I have a master list with a column of staff members names. I need a query per staff member (to load to a table/sheet in excel) Currently I have manually referen...
Hello everyone. I am running a python script and I have realized that even when my script is empty, after running it the following problem occurs: Power Query changes text types to decimal ...
Hi guys, I need help on the power query . My intention here is to remove the duplicate value for line and date . what i want is to make it so the query will only remove rows that has null value in [F...
Hello PBI folk, I have a custom function that takes a text string of numeric digits as input and is supposed to return it as a text string, but when I look at the new column, it's showing as...
Sample Files Hi there, I have multiple users uploading excel files, that follow the same template, onto a Sharepoint folder. Each of the uploaded file is following the exact same template wit...
I have a column with various prices and blank cells, I want to replace all the different $ amounts to a 'rebate' text and then all the blank cells to 'no rebate' text. I could indiviudal search the $...
Hi Everyone, I'm struggling creating a calculated column for my dataset to fix a report issue but I'm now left wondering if it is even possible as I'm only using text fields (no...