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
v-xicai's avatar
v-xicai
Community Support
6 years ago

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.

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.