Forum Discussion

aashton's avatar
aashton
Icon for Helper V rankHelper V
1 year ago

DATEDIFF with SUM not working

In Power BI I've created a table with Pay Period Start Date, Pay Period End DAte, Check Date.  I have a calculated column to find the number of days in a pay period  ( I tried a million variations of...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
1 year ago

aashton not sure how the raw data looks like, try this:

 

TotalDaysLastMonth =
SUMX(
    FILTER(
        'Pay Periods Bi-weekly',
        'Pay Periods Bi-weekly'[Check Date Last Month] = 1
    ),
    CALCULATE ( MAX ( 'Pay Periods Bi-weekly'[Days Pay Period] ) )
)
aashton's avatar
aashton
Icon for Helper V rankHelper V
1 year ago

No, same incorrect answer.