Sum of open vacancies per timeframe

[checkner]

Hey,

I am using the following code to count open requisition per timeframe. Now I want to count how many vacancies are open per timeframe. 1 job can have multiple vacancies behind it and in my table I have these values already:

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],
    "Vacancies",[Anzahl der Vakanzen]
)
VAR tmpTable1 = GROUPBY(tmpTable,[ID],"Count",COUNTX(CURRENTGROUP(),[Date]))
RETURN COUNTROWS(tmpTable1)

[v-xuxinyi-msft]

Hi  @checkner 

The data you have provided so far is a bit scanty, and I can not reproduce your formulas. Can you provide more sample data and the results you expect? So that I can help you better. Show it as a screenshot or excel. Please remove any sensitive data in advance.

Best Regards,

Community Support Team _Yuliax