Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Datesinperiod between 2 dates

Is there a way to calculate DATESINPERIOD between 2 dates?

e.g.  DATE(2020,03,01) TO DATE(2021,02,28)

 

I currently have a calculation to get 365 days ago from today but I need from 1st March 2020 to 28th February 2021:

01 Annual % Counts = CALCULATE([01 No. of Counts]/[00 Total Delivered],DATESINPERIOD('looker_views lkr_Questionnaire'[Questionnaire_DateTime],today(),-365,Day))
 
Thanks
COUNT
dates
datesinperiod
today
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Try DatesBetween

     

    01 Annual % Counts =
    CALCULATE (
    [01 No. of Counts] / [00 Total Delivered],
    DATESBETWEEN (
    'looker_views lkr_Questionnaire'[Questionnaire_DateTime],
    DATE(2020,03,01) , DATE(2021,02,28)
    )
    )

     

     

     

    01 Annual % Counts =
VAR a =
    DIVIDE (
        [01 No. of Counts],
        [00 Total Delivered]
    )
RETURN
    CALCULATE (
        a,
        DATESBETWEEN (
            'looker_views lkr_Questionnaire'[Questionnaire_DateTime],
            DATE(2020,03,01) , DATE(2021,02,28)
        )
    )

     

     

    https://radacad.com/datesinperiod-vs-datesbetween-dax-time-intelligence-for-power-bi

     

     

    Regards,

    Harsh Nathani

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Try DatesBetween

     

    01 Annual % Counts =
    CALCULATE (
    [01 No. of Counts] / [00 Total Delivered],
    DATESBETWEEN (
    'looker_views lkr_Questionnaire'[Questionnaire_DateTime],
    DATE(2020,03,01) , DATE(2021,02,28)
    )
    )

     

     

     

    01 Annual % Counts =
VAR a =
    DIVIDE (
        [01 No. of Counts],
        [00 Total Delivered]
    )
RETURN
    CALCULATE (
        a,
        DATESBETWEEN (
            'looker_views lkr_Questionnaire'[Questionnaire_DateTime],
            DATE(2020,03,01) , DATE(2021,02,28)
        )
    )

     

     

    https://radacad.com/datesinperiod-vs-datesbetween-dax-time-intelligence-for-power-bi

     

     

    Regards,

    Harsh Nathani