Forum Discussion
Quarter Days data
Solution SageYour 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
I tried the below DAX but its not working
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.
- andhiii079845
WHY [TODAY] instead of TODAY() ?
I'm using date direct from my DB.
- andhiii079845
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]))