Hi All, I have a text data of user comments that comes with speacial characters like (like Â, ’) , If I use replace function, it will delete preceding or previous occurrences of ...
Hi All When importing termstore data to power bi we get lots of unwanted text. Is there any way to just keep Oranges and Apples from the below and remove the rest? [{"Label":"Ora...
I'm in power query trying to add two custom columns. One with the previous values by month and another with the previous values by year. I need these to calculate another two columns with % MoM and %...
helpThe title can be confusing, i have 2 tables, 1 is transaltion English French German Dutch Product stability Stabilité du produit Produktstabilität Productsta...
Hello all, I am trying to load data using API which requires parameters "startDateTime" and "endDateTime" in the request URL. The data table has a date column. My plan is as follows. Run a...
I have one column of data with multiple rows, shown below. What I need to do is create 6 columns and split the data out. See second image. What I have today ...
I have 6 Tables each with completely different data and the only thing i want to filter on between them is the date to get a snap shot of statistics for a current time period. I tried copying th...
Total Value for Table on left should be 6.71, not 4.52. How can I achieve this, here is my measure applied: ft per = (((AVERAGEA('51039 BI'[Feet Installed (ft)])) / (AVERAGEA([Total ...
Hi, I want to take data from different .xlsx on SharePoint with distinct variables. And on the LoadData step it brokes with this error: DataSource.Error: SharePoint: Request failed: The remote ...
Hello, I want to make a Tree Visual and hence need to prepare my data but I'm having trouble to do so. Data Structure: I have several columns named 'Level 1', 'Level 2', 'Level 3', ...