Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a query.
I have two tables one has
ID START_DT NAME
1 04/10/2017 00:00 Test1
2 01/01/2017 00:00 Test2
3 06/05/2017 00:00 Test3
4 07/10/2017 00:00 Test4
Another table like this
ID START_DT END_DATE
2 01/01/2017 00:00 06/30/2017 00:00:00
3 06/05/2017 00:00 07/30/2017 00:00:00
1 04/10/2017 00:00
4 07/10/2017 00:00
how do i get a visualization in power bi which shows
if someone selects week1 or week 20, i want to display who people have left (which have end date) and people who are still working who dont have a end date.
I would like to give the week as a parameter or slicer. I could do thsi in SQL as a report, but i was told they want
something visually to see.
Also can the week be changed (if ISO week or our Financial week which starts from April )
Can someone please guide me.
Thanks
Sree
I have tested it on my local environment, the steps below is for you reference.
Results
Regards,
Charlie Liao
Hi charlie
Morning
I am not sure if you have seen my earlier post but just a quick question on it
When we select a week, what i need is
for people active the sql would be - where start_date is lessr than the weekday selectecd ex (05/07/2017) and end_date is null
for people who have left - it would be start_date is less than (<) weekday selected and end_Date is <= 05/07/2017
when i select the name of the person, its showing like this, is this right
Thanks
Sree
for people active the sql would be - where start_date is lessr than the weekday selectecd ex (05/07/2017) and end_date is null
for people who have left - it would be start_date is less than (<) weekday selected and end_Date is <= 05/07/2017
When you selected week, there are 5 weekdays, which one do you need to used in you measure?
Regards,
Charlie Liao
Is there a better way of selecting a from date and to date
I mean like between two dates, that would be ideal
Thanks
S
I mean like between two dates, that would be ideal
If that is the case, then my original expression would work.
Regards,
Charlie Liao
I did try your solution, i wanted the names of the person as well and when i select the field to be displayed in the table, i am not sure ifs showing the results correctly as its duplicating if you see the image below
Hi Charlie
Can you please let me know on the above
Thanks
S
Hi Liao
Thanks very much responding to me.
One more question, when i include the name in the Active People Visual, I get people who have not left also.
Ideally I would like the name of the person as well. I just included the name but it doesnt look right.
Thanks
Sri
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |