How to calculate amount by dividing the count of selected month in the slicer back to fiscal month

[gauri]

Hi,

Please Find the screen shot below :

Here i have selected Aug in the slicer , which is 5th month from April, so my new field which i want to generate would be calculated as :

 Total Amount for eg in east region is 1868 and month selected in slicer is Aug so count from slicer which i want is 5 ( April to Aug).

I will divide this amount by the count ( 1868/5) which is my required calculated field.

Also this  count which i want from slicer will change as per month ( i.e. if i select Oct the count would be April to oct i.e 7

How do i acheive this

Thanks,

Gp

[amitchandak · Accepted solution]

@gauri ,

add this column in your calendar
Start Year = Startofyear([Date],"3/31")

create a measure 

meausre =
divide(Sum(Table[Amount]), datediff(Max(Date[Start Year]),max(Date[Date]),month))

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[amitchandak · Accepted solution]

@gauri ,

add this column in your calendar
Start Year = Startofyear([Date],"3/31")

create a measure 

meausre =
divide(Sum(Table[Amount]), datediff(Max(Date[Start Year]),max(Date[Date]),month))

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[gauri]

@amitchandak This is giving me datediff as 3 if i select july month as per datediff function, whereas it should be 4

[amitchandak · Accepted solution]

@gauri , if it is less by one for all records. You can add +1