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.

foodd's avatar
foodd
Community Champion
3 years ago

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.