Find a non empity value

Todi79 — Wed, 29 Jan 2020 00:03:30 GMT

Dear i have 2 tables :

1) table1: it contains for each month the costcenter of each employee;

fields:

employee-NAME; PERIOD; CDC

XXX MARCH19 Finance

2) table2: it contains for each month the costs of eache employee.

employee-name; period;totalcosts

I have create a key in order to match for each employee name wich costcenter was associated each employee in a period.

The problem is that some periods are missing in table1 so i'd like to find the last period in table 1 to link to table 2. How can i manage it ? any idea ? thanks.

What

Re: Find a non empity value

hafizsultan — Thu, 30 Jan 2020 10:41:58 GMT

Hi,

Do you still need solution of problem. If yes, please share some sample data( 3-4 lines) of each table and I can assist you.

Cheers!

topic Find a non empity value in DAX Commands and Tips

Find a non empity value

Re: Find a non empity value