Forum Discussion

Tob_P's avatar
Tob_P
Helper V
3 years ago
Solved

Calculate Working Day Target from Annual Target

Hi,   I'd like to calculate a working day target based off an annual target. I have managed to calculate a daily sales target based on calendar days in each FY by creating a custom date column and ...
Need Help
  • Tob_P's avatar
    Tob_P
    3 years ago

    Thanks to those who gave DAX solutions to this but I wanted to solve it in Query Editor.

     

    How I did it...

     

    1. Merged my FY & Month columns

    2. Grouped Date Column & new Merged column with an output of a new column with Operation of All rows and another new column with an Operation of Count Rows

    3. Grouped the Merged column with a new column with an Operation of Count Rows

     

    ....and this then gave me the count of the number of working days within the month for month in the FY, allowing me to divide the target / number of working days.

Tob_P's avatar
Tob_P
Helper V
3 years ago

Thanks to those who gave DAX solutions to this but I wanted to solve it in Query Editor.

 

How I did it...

 

1. Merged my FY & Month columns

2. Grouped Date Column & new Merged column with an output of a new column with Operation of All rows and another new column with an Operation of Count Rows

3. Grouped the Merged column with a new column with an Operation of Count Rows

 

....and this then gave me the count of the number of working days within the month for month in the FY, allowing me to divide the target / number of working days.