Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all!
I am a new Power BI user. I have a huge problem with calculating rows from each column, where the slicer is from separate date table.
Currently I have one table Candidates with the following columns (this is a view from SQL db):
1. PhoneScreenDate
2.RecruiterSubmittalDate
2. RecruiterRejectionDate
3.RecruiterAcceptanceDate
with the dates as a value.
I would like to create a Slicer, (now it is filtered by RecruiterSubmitalDate), but we can have a situation where there were only some Phone Screens with 0 Recruiter Submitals, which will give me a chance to count all the columns.
I was trying to create a separate Calendar Table and compare every column with that but it is not working.
As a result I would like to have a table with the countrows of:
Phone Screens - one column
Recruiter Submitals - second column etc.
But it need to be a slicer with the date.
Thank you all for all your support!
@Anonymous,
You may refer to the following post.
@Anonymous Please provide some sample data and expected output, to provide any solution
Proud to be a PBI Community Champion
Hi!
The data source is SQL DB, but you will find a sample of my data below:
When it somes to the expected result, I need a table with the separate columns as: Phone Screens, Submitted to Recruiter, Accepted by Recruiter, Rejected by Recruiter.
What is the most important is the slicer with the date to choose only some period of time (we have to show the report for previous week mostly, but our client can choose any other date as well).
Thank you very much!
aleksandrajozwi.
Proud to be a PBI Community Champion
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |