Forum Discussion
help on getting a complex index
did you check my explaination previous reply
it will be very hard and sophisticating to apply such an example manually but i think by following the steps i provided at my last reply you will get the whole thing
anyway my main goal is to create summerized indexed table to hold 10% of the befining table with all filtering and sorting criterias applied
Hi Islam ,
Sorry that it will be difficult to give you a formula that suits your requirement. I am not very clear about your actual needs and the logic behind it. Especially your model is so complex... I am not clear about the fourth step and subsequent steps you mentioned, what you want to achieve in the end? Could you please provide a simple example to illustrate your requirement at each step and the final desired result? IJust for example:
| Employee Name | encauragment decision date | assigning decision date | Vacation decision date | court punishment data | punishment decision date |
| aa | xx | xx | xx | xxx | xx |
| bb | xx | xx | xx | xxx | xx |
| cc | xx | xx | xx | xxx | xx |
Desired result:
if encauragment decision date is blank, then display assigning decision date; if xxx then xxx
| Employee Name | Index |
| aa | 1 |
| bb | 3 |
| cc | 2 |
Please note that it is not necessary to provide the detailed steps, just provide the sample data, calculation logic(conditions) and your expected result. We will consider what to do to get the result you want based on your expected result...
Best Regards
I'm really feeling shamed for not being able to express my whole problem to you Mis but i'll try to give you the logic behind what my goal is specially that first solution you provided me is my promisive and seems like you got the whole problem
any way i made another post with more simplified data and in which i broke down the main goal to small problems making the whole algorith eventually
to make things clear I'm aiming to create a report of updated employees who should get an encouragement add for current year after filtering out all employees whose don't meet current year encouragement add requirements
anither question just to know i wanna filter the fact table based on conditions from different dimension tables which are not related directly I'll upload a video for what i wanna do to my fact table in excel
Hello Experts
I'm building HR system from scratch and will post every issue i face here for recommending an answer
here is a model which shows a matrix granularity over each year
for Employee Number 35 and 61 shouldn't be shown in this matrix because they retired from working so they shouldn't be shown in the matrix and here is the excel table picture showing it
so what i want here is to show employees whose not retired or died or fired in current date displaying matrix but if any employee returned to work like employee number 16 he should then be shown again in the matrix
here are both Pbix and Excel sample files
Anonymous
look here Mrs Ying here is the first required measure or method to get a filtered revised table showing wage granularity of inwork employees excluding all employees whose don't match conditions or criterias
known that my main goal here is to create HR system with Following Tools
Excel
Excel VBA
Power Query
Power Pivot