Yes, you are true in power query colors do not work. The only criteria is that if column 1 values are present in column2 or column3 then they should be shuffled to column1.
Hi,
I want to convert my current data into required form in Excel Power Query. Please refer to below link .
Transform data in required form
Regards
Dilawer
I need to add leading Zero to a column for two types of values.
1. Value containing numbers only which character length should be 9
2. Value containing Text which character length should be 10
I do it in excel with formula
=IF(ISNUMBER(A2),TEXT(A2,"000000000"),TEXT(A2,"0000000000"))
But...
Dear,
To make it simpler, Lets break it in two steps.
1. Calculate a factor by dividing :=Divide(100,000,Calulate(Sum(Table, Value),Filter(Product=ProductA),Datesbetween(Date,StardDate,Enddate))
for example outcome is 450%
2. Then Calulate(Sum(Table...
Dear Dilawer!
First you need to understand that both source tables should be linked with all tables.
1. For this you first merge Customer table & Distributor table by adding helper column (Customer name& Distributor Name)
2. Secondly you need to add helper columns in both sources which is...
Hi,
Please share formula to create measure to joint two values table (Table1 & Table2) so that further that measure can be use in more measures for analysis.
Thanks a lot
Regards
Dilawer
Dear Expert!
First of all thanks for your contribution in making things possible for learners.
I structured a set of tables and made relationships in power pivot to do following things
1. Make targets for orderbookers brand wise in currency value.
2. I want to make adjustments (calibration...
Dear Sir,
I have tried Vlookup match index and variations I know but it do not lookup values for attached table. If it is a formatting issue or other how to resolve. please help.
Regards
Dilawer
Thanks Chihiro, you are awesome... finally it get solved.. Now I need same columns for Budget and March16 and March17...will they be develop in same way.... how can i add %age variance column from last year?