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...
andhiii079845
Solution Sage
Solution SageYou can Calculated before the current date like:
My Measure =
VAR currentday = DAY(TODAY())
RETURN DAX = calculate([ARR],fiscal_day_of_quarter <= currentday)
Thanks for the response but the calculation will not solve the issue. For example tommorrow will be 1st of March and that will be 29th Day of my quarter but the variable will pick the day as 1 and the result will calculate the value based on the day = 1 for tommorrow. However it should be like 29th Day of the quarter.
- andhiii079845
Your problem is only to get for the 1st of March (if this day is today) the value (fiscal_day_of_quarter field) 29 from the Dimtable? Is this right? The both tables are in a relationship?
You can try like this as a example:DimTable[Day] is your fiscal_day_of_quarter column in the DateTable.
Fact is your second table.
Measure =
Var currentday = TODAY()
Var day = CALCULATE(VALUES(DimTable[Day]),FILTER(RELATEDTABLE('Fact'),'Fact'[Date]=currentday))
RETURN DayI 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))RETURNCALCULATE([ACV],D_DATE[FISCAL_DAY_OF_QUARTER] = day)