Forum Discussion

vijaykumarj19's avatar
vijaykumarj19
Microsoft Employee
6 years ago

substract days from date excluding week ends

i have few columns c1        c2    c3          c4             c5           c6 1 21-08-2020    11     07-08-2020       22-10-2020       2-7-2020 2 10-08-2020     6     03-08-202...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

vijaykumarj19 - 

Maybe:

 

 

C4 =
  VAR __Table = FILTER(ADDCOLUMNS(CALENDAR([C2] - [C3]*1.5,[C2]),"Weekday",IF(WEEKDAY([Date],2)<6,1,0)),[Weekday]=1)
  VAR __Table1 = ADDCOLUMNS(__Table,"Count",COUNTROWS(FILTER(__Table,[Date]>=EARLIER([Date]))))
RETURN
  MAXX(FILTER(__Table1,[Count] = [C3]),[Date])

 

PBIX is attached below sig. Table (15).

 

 

 

  • vijaykumarj19's avatar
    vijaykumarj19
    Microsoft Employee
    6 years ago

    There is no table 15 in the .PBIX file you shared

    and can we create same column in query editor