Fórum de Power BI Uma Iniciativa da Datab

A primeira comunidade de Power BI em língua portuguesa.
Antes de participar Leia as Regras e depois Apresente-se

Dúvidas relacionadas a consultas do Power Query, linguagem M, etc...
  • Avatar do usuário
  • Avatar do usuário
#6271
Bom dia Pessoal!

Vejam se podem me ajudar por gentileza:

Estou com uma planilha de dados que baixo de um sistema que as colunas dos meses vem em formato de colunas. É possível transformar isto em linhas, conforme padrão para banco de dados ? Vejam a figura abaixo. Eu gostaria que apenas as colunas númericas fossem transformadas. Eu já fiz isto manualmente no excel. Obrigado
Anexos
powerbi2.JPG
powerbi2.JPG (349.48 KiB) Exibido 129 vezes
#6272
Bom dia,
Após obter os dados, vá no editor de consultas, selecione as colunas que quer transformar em linhas ( no seu exemplo a partir da Mes 1 unid , com as colunas selecionadas vá na guia transformar , transformar colunas em linhas e transformar as colunas selecionadas em linhas.
Tnunes curtiu isso
#6283
Obrigado Virgílio!

Funcionou perfeitamente. Mas, infelizmente me deparei com um problema maior. Este meu campo que era mensal por coluna com unidade e reais, virou linha numa coluna so. Qual seria , por gentileza, o melhor caminho para eu extrair uma coluna com a data e tbm separar o que é UNIDADE e VALOR? Muito obrigado antecipadamente.

Anexei os arquivos.
Anexos
Capture10.JPG
Capture10.JPG (99.51 KiB) Exibido 105 vezes
(19.52 KiB) Baixado 3 vezes
(57.83 KiB) Baixado 2 vezes
Virgilio Aguiar curtiu isso
#6285
Boa noite,

No editor de consultas, selecione a coluna, vá na guia transformar, dividir coluna, por delimitador, selecione Personalizado e o delimitador será "_" e dividir em selecione "Delimitador da extremidade direita".

Pronto desta forma vc irá criar uma nova coluna com o tipo se é Unid ou Reais

Veja se é isso.
Anexos
(97.48 KiB) Baixado 3 vezes
#6295
Buy Quality COUNTERFEIT MONEY And fake Passports,Driver’s License,ID Cards,Visas.SSN[whatsapp +1(929) 269-6456]

Hello We are the best producers of HIGH QUALITY COUNTERFEIT Banknotes,Getting a fake and a real (genuine) passport, ID or driving
license or any other document is simple. we can make you both real and
fake documents.
However, the real documents are more expensive than the fake because
it takes time, skill and contacts to get it done. Note that, the fake
is going to be 100% unique and in very good quality. The difference is
based on the registration of the numbers. The real Document will be
registered with the country's database so you can use it to travel to
any country of your choice or in the country, mean while the fake will
not be registered but can be used as well.

Contact.....info@gwtraveldocuments.com
General support.......... gwtraveldocuments@gmail.com


fake USA(United States) passports,
fake Australian passports,
fake Belgium passports,
fake Brazilian(Brazil) passports,
fake Canadian(Canada) passports,
fake Finnish(Finland) passports,
fake French(France) passports,
fake German(Germany) passports,
fake Dutch(Netherland/Holland) passports,
fake Israel passports,
fake UK(United Kingdom) passports,
fake Spanish(Spain) passports,
fake Mexican(Mexico) passports,
buy fake South African passports.
buy fake Australian driver licenses,
buy fake Canadian driver licenses,
buy fake French(France) driver licenses,
buy fake Dutch(Netherland/Holland) driving licenses,
buy fake German(Germany) driving licenses,
buy fake UK(United Kingdom) driving licenses,
buy fake Diplomatic passports,
buy fake USA(United States) passports,
buy fake Australian passports,
buy fake Belgium passports,
buy fake Brazilian(Brazil) passports,
buy fake Canadian(Canada) passports,
buy fake Finnish(Finland) passports,
buy fake French(France) passports,
buy fake German(Germany) passports,
buy fake Dutch(Netherland/Holland) passports,
buy fake Israel passports,
buy fake UK(United Kingdom) passports,
buy fake UK(United Kingdom) driving licenses,
buy fake Diplomatic passports,
buy Camouflage passports,
buy passport Duplicates,
fake USA(united States) passports for sale,
fake Australian passports for sale,
fake Belgium passports for sale,
fake Brazilian(Brazil) passports for sale,
fake Canadian(Canada) passports for sale,
fake Finnish(Finland) passports for sale,
fake French(France) passports for sale,
fake German(Germany) passports for sale,
fake Dutch(Netherland/Holland) passports for sale,
fake Israeli passports



buy, get, fake, false, passport, passport, id, card, cards, uk, sell, online, canadian, british, sale, novelty, conterfeit, bogus, american, united, states, usa, us, italian, malaysian, australian, documents, idetity, idetification, driver, license, licence, driving, residence, permit, SSN fake passport id, free fake passport, identity theft, fake, novelty, camoflauge, passport, anonymous, private, safe, travel, anti terrorism, international, offshore, banking, id, driver, drivers, license, instant, online, for sale, cheap, wholesale, new identity, second, citizenship, identity, identification, documents, diplomatic, nationality, how to, where to, get, obtain, buy, purchase, make, build, a, passport, i.d., british, honduras, uk, usa, us, u.s., canada, canadian, foreign, visa, swiss, card, ids, document, getting, visas, cards, foriegn .

((MONEY))

This bills are not home made but industrial and professional manufacturing. From High
Quality IT techinicians from US,Russia,Korea and China We offer high quality COUNTERFEIT NOTES for the following currencies;

EUR - Euro
USD - US Dollar
DNR - DINAR
GBP - British Pound
INR - Indian Rupee
AUD - Australian Dollar
CAD - Canadian Dollar
AED - Emirati Dirham
ZAR - Rand
CHF - Swiss Franc
CNY - Chinese Yuan Renminbi
MYR - Malaysian Ringgit
THB - Thai Baht
NZD - New Zealand Dollar
SAR - Saudi Arabian Riyal
QAR - Qatari Riya

Email: info@gwtraveldocuments.com/gwtraveldocuments@gmail.com
whatsapp +1(929) 269-6456

E-Mail Your Questions and Comments.

We are looking forward to receiving your inquiries and early receipt of your first orders!

SERIOUS INQUIRIES ONLY PLEASE


Olá pessoal. Preciso usar a condiç&[…]

Conversão de hora para numero

Olá, estou precisando criar uma regra que p[…]

Me chamo taynã, estou aprendendo sobre pow[…]

Indicador atualizar só um Filtro

Boa tarde Pessoal, estou com uma dificuldade que m[…]

Treinamentos Presenciais e Online de Power BI