Forum Discussion

ToussaintSenin's avatar
ToussaintSenin
Regular Visitor
1 year ago
Solved

DAX Measure

Hi there. I am reaching out to seek your help with one of the issue I am having with calculatimg the distinct number of test done in a finanacial Month. my financial calendar table starts 1st Apr of ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ToussaintSenin ,

    Please follow the steps below:

    1. Create the start date of the financial year. If the month is less than 4, the start date is 1st Apr of previous year. If it is greater than or equal to 4, it is 1st April of the current year.

    2. Financial week starts on the 1st Monday of each week. Create a column to list the first day of each week, make sure the calculation is only based on Week and Year in Date table.

    3. Don’t forget to create a relationship between the two tables.

    4. Create a visualization, it calculates the all-test counts of each financial week in the financial Month you provided.

    5. We could also check the counts in the month you select.

    Best regards,

    Lucy Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.