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.

     

vijay273162's avatar
vijay273162
Helper III
4 years ago

Hi Greg Deckler,

 

I already have the calculation for Running Day number for current quarter - exluding weekend.

My request is to replace that day no, taken in x-axis with current-quarter date.

So, if you download the .pbix file, you can check my "help column" in "calendar table".

 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

vijay273162 Or maybe this?

Current Quarter date = 
  IF(
    ISBLANK([Running Day - Excluding Wknd.]),
    BLANK(),
    DATE(2022,MONTH([Date]),DAY([Date]))
  )