Need help for expression in paginated report when any parameters is Blank()

[ashmitp869]

Hi All,

I am doing a paginated report, where I got a requirement that I don't select any month i.e MonthName is Blank() then it should calculate for the whole Year for the mentioned expression (Claim Qty, Claim Total)

I used the below expression for the Claim Qty which is giving me #Error. Please kindly with the expression .

=Sum(IIf(
    (Parameters!DateMonthName.Value(0) = "" Or IsNothing(Parameters!DateMonthName.Value(0)) ) And (Parameters!DateYear.Value(0) = Fields!Year.Value),
    Fields!BilledQuantity.Value,
    IIf(
        Parameters!DateMonthName.Value(0) <= Fields!MonthName.Value And Parameters!DateYear.Value(0) <= Fields!Year.Value,
        Fields!BilledQuantity.Value,
        Nothing
    )
))

@SamWiseOwl  @v-henryk-mstf   will you please help.

Thanks

[SamWiseOwl]

Hi @ashmitp869 

I am not that familiar with Power BI Paginated reports.

However a couple of points to make it easier for others:

• What does the error message say?
• Parameters!DateMonthName.Value(0) = "" sounds like you are testing a date against string

[ashmitp869]

Hi,

Parameters!DateMonthName.Value(0) is

Here is my error. Not showing in details. the MonthName is passing Blank().