Forum Discussion
Quarterly Ratio
hi, this is not what I meant - I am aware of this time intelligence functions.
I just need a dynamic ratio, quarterly ratio displayed as %...
Hi Czempijan ,
You may create measure like DAX below.
Quarterly Ratio=
Var _DayRank=CALCULATE(COUNT(Table1[Date]),FILTER(ALLSELECTED(Table1), YEAR(Table1[Date] )=YEAR(MAX(Table1[Date]))&&MONTH(Table1[Date] )=MONTH(MAX(Table1[Date]))&&Table1[Date] <=MAX(Table1[Date])))
Return
_DayRank / [number of days for the quarter column]
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks, I did not understand the last part :
_DayRank / [number of days for the quarter column]
so by what I shall divide?
Thanks,
Hi Czempijan ,
>>I have a column that gives me number of days for the quarter, say 10th of Jun is 42nd day in a 92 days within the quarter ( I have different fiscal calendar).
It is referred to the "column that number of days for the quarter" in your words above, and it is 92 in your scenario currently, right?
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi, yes but it is a column I need this as a measure not as a column is it possible?