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...
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...
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...
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
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.
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
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)...
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...
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...
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...
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...
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...