Forum Discussion
Quarter Days data
Hi All, I have a visual in my report where I'm showing data Q/Q like below. What bussiness wants is that I should show the exact same day's data for each quarter for example today is...
I tried the below DAX but its not working
Measure =
Var currentday = [Today]
Var day = CALCULATE(VALUES(D_DATE[FISCAL_DAY_OF_QUARTER]),FILTER(RELATEDTABLE(F_ACV),F_ACV[CLOSE_DATE]=currentday))
RETURN
CALCULATE([ACV],D_DATE[FISCAL_DAY_OF_QUARTER] = day)
I'm using the below calculation for the time being to get the desired result. the issue with this DAX is I'll have to add the previous months days to the calculation like tommorow I'll replace 0 with 28 in my calculation.