Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
checkner
Frequent Visitor

Average Applications per job requisition

Hello,

I have a total of 2 tables with data. The first table contains all the applicant data (application date, vacancy ID etc.) and the second table contains all the data on the job advertisements (vacancy ID, opened on, closed on etc.).

 

Currently, I already have an overview of the corresponding applications per selected date and an overview of the positions open at a certain date (see formula).

 

checkner_0-1697449241752.png

 

 

Requisition Open = 
VAR tmpTickets = ADDCOLUMNS('Report (2)',"Effective Date",IF(ISBLANK([Geschlossen am]),TODAY(),[Geschlossen am]))
VAR tmpTable =  
SELECTCOLUMNS(
    FILTER(
        GENERATE(
            tmpTickets,
            'Calendar'
        ),
        [Date] >= [Erstellungsdatum] &&
        [Date] <= [Effective Date]
    ),
    "ID",[Stellenanforderungskennung],
    "Date",[Date]
)
VAR tmpTable1 = GROUPBY(tmpTable,[ID],"Count",COUNTX(CURRENTGROUP(),[Date]))
RETURN COUNTROWS(tmpTable1)

 

 

How can I now create an overview from this by showing in a diagram how many applications have arrived on average?

1 REPLY 1
lbendlin
Super User
Super User

You include a Calendar table in your data model, and create measures for the selected intervals.

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors