Forum Discussion

DM_BI's avatar
DM_BI
Icon for Helper III rankHelper III
7 years ago
Solved

Days between 2 dates in same table and by month name

Hello,   I have a table that has three columns, one is the person ID, one is the date they entered and the last column is the date they left. I am trying to create a new table on Power BI that calc...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi DM_BI 

You may create a measure like below:

Measure = 
CALCULATE (
    COUNTROWS ( DimDate ),
    FILTER (
        GENERATE ( DimDate, Hoja1 ),
        Hoja1[Admit] < DimDate[Date]
            && Hoja1[Departure] >= DimDate[Date]
    )
)

Regards,