• 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. G

    writeback to PowerPivot datamodel/table

    Hi Powerpivot expert This forum was of great help to learn powerpivot especially feedback from Ninja Chihiro am not sure if there is way or workaround to do data write back to Powerpivot table i.e. for unique key after generating report we can added free text and reason code for identified...
  2. G

    #3 Followup dynamic slicer on dimension table for Report agains data in fact table.

    Hi Chihiro, Thanks again, will do the testing over weekend and revert.
  3. G

    #3 Followup dynamic slicer on dimension table for Report agains data in fact table.

    Hi Chihiro Hopefully, i be able to clarify 1. In 1st screen image KPI status is derived on one value across all Zone- attributes to identify Green, Amber,Red based KPI% ( if <10% G, 10% ~ 50% A, >50%R) image 2. However what business has, for each attribute of Zone a different KPI tolerance...
  4. G

    #3 Followup dynamic slicer on dimension table for Report agains data in fact table.

    Hi do we have suggestions on the query! or i need to provide additional information. regards Kumar
  5. G

    #3 Followup dynamic slicer on dimension table for Report agains data in fact table.

    Hi Ninja's This is follow-up, following solution view provided by Ninja -Chiriho for earlier query ,Help to create data model in Powerpivot for Flat table (fact table). Using the guidance provided earlier , have reach in the good shape on complex calculation to arrived required measure on...
  6. G

    2# lookup value in Power pivot with find/search within same fact table.

    Hi Chihiro, Many thanks again, its perfect... will try to understand the DAX firstnonblank on Microsoft site. Hi GraH thank, this help to but need to spend some time of learning power query split and merge
  7. G

    2# lookup value in Power pivot with find/search within same fact table.

    Hi Chihiro and GraH Have uploaded the sample raw data file with my current excel formula output. Have not attempted to create data model or load in power pivot as believe it easy work new file the do correction.
  8. G

    Help to create data model in Powerpivot for Flat table (fact table)

    Hi Chihiro, Many thank and may you be blessed wherever you are. This will help me compared with what i did yesterday night, i finally managed using same file and based on your earlier inputs to arrive at least at the aggregation. your solution looks perfect, many thanks again
  9. G

    2# lookup value in Power pivot with find/search within same fact table.

    Hi Reaching out to this forum ( looks is great on power pivot :) ) for help to have lookup for below scenario in data table (which is within the data table). Not sure about how to manage in DAX (PowerPivot) my current excel formula Lookup(excel)...
  10. G

    Help to create data model in Powerpivot for Flat table (fact table)

    Hi Chihiro thanks and appreciate your support to pass on knowledge. Yes there can be values in some cases below 0 thus business want to be specific to have value to start on 0. If it below zero it is outliers in those case due to errors hence ignored and addressed differently. Understand, no...
  11. G

    Help to create data model in Powerpivot for Flat table (fact table)

    Hi Chihiro, thanks mate, file helped to give insight on how to manage with power query, have download power query on my system now. "I'm still bit unclear as to what end result you are after." may be you were right to sense something was amiss. On of the reason i have created data model was...
  12. G

    Help to create data model in Powerpivot for Flat table (fact table)

    Hi Chihiro, Thanks for the reply, unfortunately am new to power query and powerpivot :( Is it possible to upload file with changes as suggested by yourself so that later i can replicate same on my mail file( i tried several options ..for last two weeks). 1st place am not sure way i have...
  13. G

    Help to create data model in Powerpivot for Flat table (fact table)

    Hi Narayan, I cannot upload actual data but the structure of my file is mirror image of actual data. What i want to achieve and required. Flat file structure i cannot change to tabulate ZONE however client need to measure Zone based on the tolerance limit and also have filter functionality...
  14. G

    Help to create data model in Powerpivot for Flat table (fact table)

    Hi Experts Looking for suggestion on Data model(PowerPivot) with Fact and dimension for below Fact table on which i need to measure KPI for "ZONE" with filter option on Area and Region [ fact Table ( below is example of 60000 R and 90 C) ] I have create 3 dimension tables 1. Area ( Primary...
Back
Top