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 or try this:

 

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

Syntax error on this, missing a comma??

 

TotalDaysLastMonth =
SUMX(
    SUMMARIZE (
      FILTER(
          'Pay Periods Bi-weekly',
          'Pay Periods Bi-weekly'[Check Date Last Month] = 1
       ),
       'Pay Periods Bi-weekly'[PayPeriodStart],
       'Pay Periods Bi-weekly'[PayPeriodEnd],
       'Pay Periods Bi-weekly'[Days Pay Period] )
    )
    [Days Pay Period]
)