annual
1 Topic
Dax annual % 365 days ago from today
I have a measure created to capture the amount of falls % but I was hoping to calculate this on an annual % (based from today -365 days) Is this possible? Here's what I have so far Annual % Falls = CALCULATE ([01 Falls %], FILTER ( 'looker_views lkr_Questionnaire', 'looker_views lkr_Questionnaire'[Questionnaire_DateTime] >= MIN( 'looker_views lkr_Questionnaire'[Questionnaire_DateTime] ) && 'looker_views lkr_Questionnaire'[Questionnaire_DateTime] <= MAX ( 'looker_views lkr_Questionnaire'[Questionnaire_DateTime] ) ) )Solved2.4KViews0likes1Comment