Hola, La TABLA1 = Es una tabla de donde obtengo los paros de una maquina através de su PLC. Necesito tener los paros por turno y cuando hay un cambio de turno, ya sea de mañana a tarde, de ...
Dear all, in my database the power (kw) of electrical energy of a system is recorded every two seconds. Over the course of 24 hours there are data different from zero (when the system is on) and dat...
Hi, I have imported an excel file into power bi and using power query to clean my data. The image below shows that my first column has dates. This column contains the latest date in my data,...
I want to Pivot Item Types but for ItemFTE and ProratedSalaryAllocation. I can only do one of those columns but not both. Is that even possible? This is the only way I am ...
Hello , I have a date column that is sorted incrised only by the day information. Is it possible to sort the whole date by ascending order ? I mean i dont want the Novemver to be appearing ex...
I have an On-Hire table that lists all transactions or instances where my customers hire equipment. e.g. Lawn Mower was hired by Customer 1234 on January 18, 2024 and agrees to return the item on 19...
I am adding 14 conditional columns, which I am doing in 14 steps. This seems like a very clunky way of doing it, and I'd prefer to do it in 1 step if possible. This is how each step looks li...
Hi folks, I am quite new to powerQuery, and I would appreciate your assistance. I have a table with data from different fiscal year, including the fiscal year - which is not at ...
Hi, I'm new to power BI and am making a power BI report, I have imported data from a MS Sharepoint folder (so it's in the cloud for my company and not local) and picked out the specific excel ...