Average sum using Date slicer in Power BI

[Analitika]

Hello,

I would like to ask how to calculate average sum using Date slicer, when selecting year, month etc. Here how looks date slicer.

What measure to use, I used measure like this:

divide(

[sum],[selected_month]).

selected_month=

Pasirinkta menesiu =

SWITCH(

TRUE(),

ISFILTERED(_Date[Date].[Month]), IF(QUOTIENT(COUNT(_Date[Date].[Month]),30)=0,1,QUOTIENT(COUNT(_Date[Date].[Month]),30)),

IF(QUOTIENT(COUNT(_Date[Date].[Month]),30)=0,1,QUOTIENT(COUNT(_Date[Date].[Month]),30))

)

But it works when data is per 12 month, if appears several months, it gives wrong value.

[Anonymous]

Hi @Analitika,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

In addition, you can also try to use the following formula if hleps:

selected_month =
MIN ( COUNTROWS ( SUMMARIZE ( ALLSELECTED ( Table ), [Year], [Month] ) ), 1 )

Regards,

Xiaoxin Sheng