Forum Discussion

bhelou's avatar
bhelou
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

wrong dates in line chart

Dear , I have this measure for the Balances the measure giving correct resutls in table but when making as a line chart and puting the dates , the value is correct but the dates are showing till the ...
  • PVO3's avatar
    4 years ago

    It's hard to guess. Buyt you could try something like this.

     

    AP_TRIAL_BALANCE_OPENNING_BALANCE =
    VAR Openning_Debit =

    CALCULATE (
    [AP_TRIAL_BALANCE_DEBIT],
    FILTER (
    ALL ( '*Dates' ),
    '*Dates'[Date] < MIN ( '*Dates'[Date] )
    )
    )

    VAR Openning_Credit =

    CALCULATE (
    [AP_TRIAL_BALANCE_CREDIT],
    FILTER (
    ALL ( '*Dates' ),
    '*Dates'[Date] < MIN ( '*Dates'[Date] )
    )
    )

    VAR Openning_Balance = Openning_Debit - Openning_Credit

    RETURN

    CALCULATE(
    IF (
    ISBLANK ( Openning_Balance ) && MAX(fact table[date]) <= MAX('*Dates'[Date]),
    0,
    FORMAT(Openning_Balance, -0.000)
    )
    )

  • bhelou's avatar
    bhelou
    4 years ago

    Thank you  very much it worked 
    CALCULATE(
    IF (
    ISBLANK ( Openning_Balance ) && MAX(fact table[date]) <= MAX('*Dates'[Date]),
    0,
    FORMAT(Openning_Balance, -0.000)
    )
    )

  • bhelou's avatar
    bhelou
    4 years ago

    This is the working Variab;e , Thanks , 

    CALCULATE (
    IF (
    ISBLANK ( Openning_Balance ) && NOT ( ISBLANK ( COUNTROWS ( '*Dates' ) ) ),
    0,
    Openning_Balance
    )
    )