Forum Discussion
DDLINE CHECKING
Newbie here,
Is there any way to get the DDLINE based on a filtered calendar table.
For example:
CALENDAR TABLE (filtered all the weekends and holidays)
OUTPUT TABLE: (get the DDLINE based on the calendar table above that has no weekends and holidays)
Thank you so much for your help! Rally appreciate it 🙂
Hi Anonymous ,
You could add a new index column for the calendar table.
Then create below formulas.
Column = LOOKUPVALUE('CALENDAR'[Index2],'CALENDAR'[date],OUTPUT[date])+OUTPUT[duration] Column 2 = CALCULATE(MAX('CALENDAR'[date]),FILTER(ALL('CALENDAR'),'CALENDAR'[Index2] = OUTPUT[Column]))Best Regards,
Jay
5 Replies
Anonymous , if you want to add working days, refer to my blog
Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766
Hi amitchandak ,Thank you for your insights. However, i don't like to add working days. I just wanted to count the days starting from ENDORSED DATE of the project until it's ddline based on DURATION column . but i want to count it based on another CALENDAR TABLE that has no weekends and holidays . so if you can see the orange table above . that is the calendar table that has already no weekends and holidays and I've filtered it already in Power Query.
Anonymous , A new column in the second table
countx(filter(CALENDAR, CALENDAR[Date] >=Table[Date] && CALENDAR[Date] <=Table[DEDLINE]),CALENDAR[Date])
In case the first table has a flag for the workday add that to calculation
Second page of attached file shows measure way
Hi Anonymous ,
You could add a new index column for the calendar table.
Then create below formulas.
Column = LOOKUPVALUE('CALENDAR'[Index2],'CALENDAR'[date],OUTPUT[date])+OUTPUT[duration] Column 2 = CALCULATE(MAX('CALENDAR'[date]),FILTER(ALL('CALENDAR'),'CALENDAR'[Index2] = OUTPUT[Column]))Best Regards,
Jay
