Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Date table DAX Help

Hi All,   I have a an attendance table which is tied to a date table. Issue I am having is there isnt data for every single day. I want the 0 days to count e.g.   Mon - 0% Tue - 0% Wed - 7% Th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey,

 

That adds 0 at the Year level not the day level

 

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

ok, I have overseen something. Can you please try the following:

 

AVG % (M-F) = 

VAR WeekdayTable = 
   FILTER(dDates, dDates[DayOfWeek] <> 6 && dDates[DayOfWeek] <> 0 && dDates[Year] = 2022)
RETURN
AVERAGEX(WeekdayTable, [DailyAttendance] + 0)

 

Best regards

Michael

-----------------------------------------------------

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

@ me in replies or I'll lose your thread.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hey, this seems much closer than what I initially had but for the below calendar week where the highlighted falls, the answer should be 1.4% because Mon, Wed, Thu, and Friday are 0% but Tuesday is 6.6%. Im struggling to see what Im missing 😞

     

     

    • Mikelytics's avatar
      Mikelytics
      Resident Rockstar
      3 years ago

      Hi  Anonymous 

       

      what really confues me is that you one the one hand speak about weeks but on the other hand you put single dates into the visual and in a previous picture you put year values into a bar chart.

       

      Can you please show the data model and explain the meening of the columns in your table visual?

       

      Best regards

      Michael

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago


        I created a date table that has all the different dimensions