Forum Discussion

wherdzik's avatar
wherdzik
Helper III
2 years ago

Two time Frames on Same Graph

Hi built this dashboard and the user wants two differnet time frames. So when I pick the month some of the statistics that that have a YTD prefacing it.  They have to be on a YTD basis so If I select...
Need Help
  • wherdzik's avatar
    wherdzik
    Helper III
    2 years ago

    Can you help me with the logic?  I tried getting ChatGPT to help me but it is not working.  Here is my dax code that it suggested:

     

    AveragePatientsPerDoctorYTD = 
VAR SelectedDate = MAX('SEP YTD'[Service Date].[Day])
VAR YTDStartDate = CALCULATE(
    MIN('SEP YTD'[Service Date].[Day]),
    ALL('SEP YTD'[Service Date]),
    'SEP YTD'[Service Date].[Year] = YEAR(SelectedDate)
)
VAR TempTable = 
    ADDCOLUMNS(
        FILTER(
            'SEP YTD',
            'SEP YTD'[Service Date] >= YTDStartDate && 'SEP YTD'[Service Date] <= SelectedDate
        ), 
        "DistinctPatientsPerDate", CALCULATE(COUNTROWS(SUMMARIZE('SEP YTD', 'SEP YTD'[Patient Name])))
    )
VAR TotalPatients = SUMX(TempTable, [DistinctPatientsPerDate])
VAR TotalDays = COUNTROWS(TempTable)

RETURN
IF(
    TotalDays > 0,
    DIVIDE(TotalPatients, TotalDays),
    BLANK()
)

    Here is my data set.  Esentially I want to select February and have, in this case Average Visits Per day on a YTD basis. 

     

    Here is what my data looks like for reference.  I just cannot get it to work.