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 ...
Need Help
  • PVO3's avatar
    PVO3
    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
    )
    )
PVO3's avatar
PVO3
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi,

 

You should remove the * -1 at the end of your variables.

Perhapse change this to something like below (depending on regional preferences).

FORMAT ([measure] , -0.000) 

 

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

Dear , 

i Made it like this but gave me error couldnt display any visiual 

AP_TRIAL_BALANCE_OPENNING_BALANCE =
VAR Openning_Debit =
FORMAT(
CALCULATE (
[AP_TRIAL_BALANCE_DEBIT],
FILTER (
ALL ( '*Dates' ),
'*Dates'[Date]
< MIN ( '*Dates'[Date] )
)

),-0.000)
VAR Openning_Credit =
FORMAT(
CALCULATE (
[AP_TRIAL_BALANCE_CREDIT],
FILTER (
ALL ( '*Dates' ),
'*Dates'[Date]
< MIN ( '*Dates'[Date] )
)
),-0.000)
 
VAR Openning_Balance = Openning_Debit - Openning_Credit
RETURN
CALCULATE(
IF (
ISBLANK ( Openning_Balance ),
0,
Openning_Balance
))

formating it didnt work 

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

    Dear , 

    I have removed the if condition ( is blank  ) but in the visual card is giving me blank now i need it 0 ...

    CALCULATE(
    IF (
    ISBLANK ( Openning_Balance ),
    0,
    Openning_Balance
    ))