Hi, I am trying to replace values based on its own condition. I want [Part number] column to be [common part]. If the part number starts with 999, then it becomes...
Hi All, I have a csv file with the following format below ]H]mm:ss, but the Query Editor is treating this as text. How best can I convert this to hh.mm.ss? When I try to convert it to anything else, ...
Hi, I'm posting this question after researching and not finding similar question brought up. I have report that shows the initial quantity, quantity in and quantity out and the week number, I would ...
Hi All, I am getting an error in PowerBI when I try to refresh the report on certain steps in PowerQuery but when I open Powerquery and hit refresh the error dissapears and the query is work...
I need to recreate an excel formula in power bi and make this a new column, but not with DAX, if I'm not mistaken I need to do it with the M language, but I don't know how to do it THIS IS MY FORMUL...
Hi All, I need your assitance to split the below data to different columns like Weekday in one column and Hours in one column. Expected format either of the 2 below. ...
Hi ! Simple question I guess but cannot solve it. I have a column with Year & Week in text format e.g. 202408 (Year 2024 and Weekno 08). How do I convert this into a datecolumn?
Hi all, I have a column with date values of the following format: 26-27 Jan, 44313, 25 Oct - 01 Nov and would like to convert this single column into 2 columns, start and end date like the below...
From the series of columns identify the first time I change the value, resulting in the header name of that column. And in another column identify the last value before the change, also with the nam...