Forum Discussion
Help Networking day formula needed
Hello All, Full disclosure: I am not a programmer. I am newer to Powerbi and all knowledge is self taught so I will not be offended if you explain in laymans terms. I am having an issue find...
Text colouring hasn't appeared in the post.. I'm assuming the formula you are speaking of is this one?
IF('All Reports'[SLA]="PA1-Reg>5D_Prior",sumx (FILTER('Table - Date','Table - Date'[Date].[Date] <= 'All Reports'[Receipt/Creation Date].[Date] && 'Table - Date'[Date].[Date] >= 'All Reports'[EffectiveDate].[Date]), 'Table - Date'[Workday])
Should the below be returning 1 for working day and -1 for non-working day?
'Table - Date'[Workday]) = a column showing “1” for working day and “0” for non-working day.
I'd need a bit more information on the formula in order to help.