Forum Discussion

Mardo's avatar
Mardo
Frequent Visitor
8 years ago

Please Help me with my Dashboard!

   
Need Help
Chas2002's avatar
Chas2002
Icon for Helper III rankHelper III
8 years ago

Hi Mardo,

 

Can you share your table with some dummy data? 

 

Normally, for reports similar to this I use a flag column in my database, but you may be better off with a flag and date column. 

 

For example:  Flag = 0 (default) means no change in employment, Flag = 1 means employee left company, Flag = 2 means employee joined company.  Then the date is would show the date the flag occured.  Something similar may work for you.

 

Chas

Mardo's avatar
Mardo
Frequent Visitor
8 years ago

Hello Chas,

 

I have created two different tables from the main CUBE. The first table contains 1544 rows and shows the employee in 2017. The second table has 1804 rows that shows the number of employees in 2018. (The number of employees is increasing!).

 

Now, my question is: HOW to determine the number of employees who left OR joined the company??? We have Employee-ID as a key in both tables. Please anyone could help?

 

Thanks in advance,

Regards,

Mardo

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Mardo,

     

    BTW, it will be help if you share some sample data/pbix file and expected result to help clarify your scenario.

     

    In my opinion, I think you can try to union these table and create new tables to store expand details date from merged table.

    Then you can direct use calendar table to link detail date to create visualizations.

    Convert date ranges into list of dates?

     

    Regards,

    Xiaoxin Sheng