Forum Discussion

Islam's avatar
Islam
Helper V
5 years ago

help on getting a complex index

  Hello Everyone I'm having a trouble creating the following steps measure of indexing a table to get then the top values 1- first we must filter out any employee who had a vacation during the las...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

Islam's avatar
Islam
Helper V
5 years ago

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

  • Islam's avatar
    Islam
    Helper V
    5 years ago

    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

    Sample BI 

    Sample Excel 

     

  • Islam's avatar
    Islam
    Helper V
    5 years ago

    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