Forum Discussion

Ezzeldin's avatar
Ezzeldin
Icon for Helper I rankHelper I
2 years ago

Total error when Retrieve the last available value from a table.

Dears, This is a link for the Power BI file of the below-demonstrated Case: https://www.dropbox.com/scl/fi/8d5sz6w4ksjhr6z9312dr/Use-Case.pbix?rlkey=nytwo1qj4w3tylaatarttqog6&dl=0   I have a tabl...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Ezzeldin 

Check enclosed file. I created two measures as below.

I check for two GL ID's as shown on picture below

Sum_simple sum =
--simple sum formula
SUM(BRU_Facility_Limit[Facility_Limit])
 
Sum adjusted =
IF (
    ISEMPTY ( BRU_Facility_Limit ),
    CALCULATE ( [Sum_simple sum], OFFSET ( -1,, ORDERBY ( 'DATES'[Date] ), ) ),
    [Sum_simple sum]
)

 

 

Ezzeldin's avatar
Ezzeldin
Icon for Helper I rankHelper I
2 years ago

if gives me an error.