Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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)
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

WHY [TODAY] instead of TODAY() ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I'm using date direct from my DB.

    • andhiii079845's avatar
      andhiii079845
      Icon for Solution Sage rankSolution Sage
      3 years ago

      Please try my solution first. you also use today() in your first post.
      What is [TODAY] ? a Column with one value? 
      Than you can try something like Var currentday = calculate(VALUES([Today]))

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        The day number is coming correct using your measure but how to calculate the total fact amount i.e ACV here, DAX doesnt allow me to use calculate with the measure created.