Forum Discussion

Czempijan's avatar
Czempijan
Helper II
6 years ago

Quarterly Ratio

Hi,   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). Now I want to have a ratio of 42...
Need Help
Czempijan's avatar
Czempijan
Helper II
6 years ago

hi, yes but it is a column I need this as a measure not as a column is it possible?

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Czempijan ,

 

If you need a calculated column, then you may create columns like DAX below.

 

YearMonth= YEAR(Table1[Date] )*100+ MONTH(Table1[Date] )



Quarterly Ratio=

Var _DayRank=CALCULATE(COUNT(Table1[Date]),FILTER(ALLSELECTED(Table1), Table1[YearMonth] )= EARLIER(Table1[YearMonth]) &&Table1[Date] <=EARLIER(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.