Forum Discussion

vijay273162's avatar
vijay273162
Helper III
4 years ago
Solved

Calendar Table help

Hi All, Attached my Calendar Table for help on creating 1 Calulcated column.   https://drive.google.com/file/d/1I9cTfS9Dta6U2SrqBxCbT8Xk7OGGAStH/view?usp=sharing   Below is the snapshot of What ...
Need Help
Show and Tell
Tips and Tricks
  • vijay273162's avatar
    vijay273162
    4 years ago

    Here is the solution. Hpe it helps others !!

     Create a calculated table (only taking the current Quarter Date ) in it.

    Use LOOKUPVALUE syntax, to bring the date into Business Day no. irrespective of Year.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

vijay273162 Not sure I 100% understand. You want to have the x-axis be the day # of the quarter excluding weekends? Like:

Day Num of Quarter Column = 
  VAR __Date = [Date]
  VAR __Year = YEAR([Date])
  VAR __Quarter = QUARTER([Date])
  VAR __Table = 
    FILTER(
      ADDCOLUMNS(
        FILTER(ALL('Calendar'),YEAR([Date]) = __Year && QUARTER([Date]) = __Quarter)
        "Weekday",WEEKDAY([Date],2)
      ),
      [Weekday] < 6
    )
RETURN
  COUNTROWS(FILTER(__Table, [Date] <= __Date))