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 21st Feb and 21st day of the quarter for me so each quarter in the visual should show data for the first 21 days only instead of showing the complete consolidated data for that quarter.
I have the fiscal day column in my dataset. How should I get this thing done?
I have a measure created as well which I'm showing against these quarters. the values is ARR.
so I want something like
DAX = calculate([ARR],fiscal_day_of_quarter <= Today()).
But this is not giving the correct info here.
12 Replies
I want something like below where I can get values for 1st day of the quarter to the present day of the quarter.
How to get this through DAX so that it gets dymanic??
amitchandak Greg_Deckler FreemanZ any help here?
Instead of the hard coded value of "21" I want the current quarter day number there
You 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.
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 Day
