Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Sirs,
I have a table like this:
Employee ID | Wage From | Wage Until | Wage |
001 | 2018-01-01 | 2018-08-05 | 1000 |
001 | 2018-08-06 | 2019-01-15 | 1200 |
001 | 2019-01-16 | 1300 |
This is an example of one employee and his history of wages.
What i want is a line chart of every day and check what wage this employee has on that moment.
So for employee 001 it means that when the time frame or date filters are between 2018-01-01 and 2018-08-05, the wage is 1000.
Kind regards.
Solved! Go to Solution.
use a calcluated table
first go into the data view
select the modeling tab
click new table
in the formula bar enter the dax below and change the required table names
Proud to be a Super User!
use a calcluated table
first go into the data view
select the modeling tab
click new table
in the formula bar enter the dax below and change the required table names
Proud to be a Super User!
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |