• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. dilawer5

    Power Query Data Transform

    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.
  2. dilawer5

    Power Query Data Transform

    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
  3. dilawer5

    Power Query: Add Leading Zero if Value contain Alphabets

    Perfect! Thanks Chihiro you are such a wonderful guy
  4. dilawer5

    Power Query: Add Leading Zero if Value contain Alphabets

    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...
  5. dilawer5

    Increase Sales Value upto a Number

    Here is the example file
  6. dilawer5

    Increase Sales Value upto a Number

    Yes, Here is the sample file.
  7. dilawer5

    Increase Sales Value upto a Number

    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...
  8. dilawer5

    Increase Sales Value upto a Number

    Hi, I need to increase values of salestable(value column) upto a certain total value of 100,000. Please see below example.
  9. dilawer5

    Combine Two Source Tables with Different Relationships in dimension table columns

    Yes, I looked my question from an expert view and a thought to share it may be it help others. Thank you Chihiro as ever you are there to help.
  10. dilawer5

    Combine Two Source Tables with Different Relationships in dimension table columns

    Thank You Dilawer, But I dont want to merge both source tables
  11. dilawer5

    Combine Two Source Tables with Different Relationships in dimension table columns

    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...
  12. dilawer5

    Combine Two Source Tables with Different Relationships in dimension table columns

    A formula or a way through which two sources should act like one source table. Regards
  13. dilawer5

    Hi Khalid bhai, I want to give you a little project, power pivot. power query and Power BI

    Hi Khalid bhai, I want to give you a little project, power pivot. power query and Power BI
  14. dilawer5

    Create Measure to Joint two values tables DAX

    Thanks Naryan, Will this new talbe in result of unionformula , be used in all calculate formulas???
  15. dilawer5

    Create Measure to Joint two values tables DAX

    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
  16. dilawer5

    TWO WAY LOOKUP FROM NONRELATED TABLE

    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...
  17. dilawer5

    lookup formulas not working

    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
  18. dilawer5

    %age Growth based on Filter Power Pivot

    Dear Need following two columns to be added in Power Pivot. Power Pivot Excel 2013 is used.
  19. dilawer5

    Dashboard for MTD and YTD Comparisons in One Pivot Table

    I tried many times formula in step 12 but not able to apply. It gives error on &&. Please check formula on attached. Thanks a lot
  20. dilawer5

    Dashboard for MTD and YTD Comparisons in One Pivot Table

    It is giving following error while creating lookup table in power query...Can u please respond asap...thx
  21. dilawer5

    Dashboard for MTD and YTD Comparisons in One Pivot Table

    Chihiro! you have saved me and 5 others a lot of time and panic. Thanks again
  22. dilawer5

    Dashboard for MTD and YTD Comparisons in One Pivot Table

    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?
  23. dilawer5

    Dashboard for MTD and YTD Comparisons in One Pivot Table

    Yes Sir, Year Starts from July to Jun
  24. dilawer5

    Dashboard for MTD and YTD Comparisons in One Pivot Table

    Here is the raw data with must columns. Plz apply dax formula in power pivot to get YTD sales and same period last year sales.
  25. dilawer5

    Dashboard for MTD and YTD Comparisons in One Pivot Table

    I am searching for below solution but in power pivot.
Back
Top