An argument of function 'DATE' has the wrong data type or the result is too large or too small.

[Analitika]

I need to crete filter by week ranges

Now 

Range = 

var Year1 = 'Date'[Date].[Date]

var Year2 = INT('Date'[Year])

VAR conc= ROUNDDOWN(DIVIDE('Date'[WeekN]-1,4),0)

var WeekS= format(if(conc=0, 1, conc*4+1),"#")

var WeekEnd= format(CALCULATE((conc+1)*4),"#")

return

WeekS & "-" & WeekEnd

but when i select whool range i got error in visuals or do not showing info at all

Error Message:
MdxScript(Model) (332, 13) Calculation error in measure 'DK'[rate %]: An argument of function 'DATE' has the wrong data type or the result is too large or too small.

rate % =

var earnings= [LY]

VAR midC= MAX('Date'[Date])

var midC2= date(year(midC)-1,MONTH(midC),DAY(midC))

var stock1 = CALCULATE(sum([sum]), FILTER(ALL('Date'[Date]),'Date'[Date]<=midC))

var stock2 = CALCULATE(sum([sum]), FILTER(ALL('Date'[Date]),'Date'[Date]<=midC2))

VAR new= DIVIDE(earnings,stock2 )

var old= DIVIDE([CountS],stock1 )

RETURN

FORMAT((new-old),"0.00%")

[Icey]

Hi @Analitika ,

Please let me know if the link I post above is helpful.

Best Regards,

Icey

[Analitika]

TY, your post is not helpful

[amitchandak]

@Analitika , rate %  seems correct. Unless there is an error Range. Can you check them separately.

[Analitika]

error only if whoole group of week select, if selected week separately everithing work

[FarhanAhmed]

All looks ok , are you using date in measures of [LY] or [CountS] seems like problem happening at these measures.

[Analitika]

countS =
ROUND (
    CALCULATE (
        CALCULATE ( SUM ( [sum2] ) ),
        FILTER (
            'T1',
            'T1'[Table] = "t"
                && NOT 'T1'[item] IN { "1", "2", "3" }
        )
    ),
    0
)

LY = CALCULATE ([countS], dateadd( 'Date'[Date],-1,YEAR))

No matter which measure,  every measure return empty if whoole weeks range selected, and return sums if selected separetly weeks

[Icey]

Hi @Analitika ,

Please check if this post helps:

An Argument of Function Date has wrong data type or result is too small or too large Error

In addition, are [sum] and [sum2] measures? If they are, need to use SUMX inteading of SUM function.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it more quickly.