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 use some of "share" programs like Office 365, Dropbox, Google Drive...sharing link (hide sensitive info)

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

done, please check the main post.

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Ezzeldin  I wil check it and let you know.

    • some_bih's avatar
      some_bih
      Icon for Community Champion rankCommunity Champion
      2 years ago

      Hi Ezzeldin 

      Please check your Dates table relationship, usually it should be active and after that play again with dates year and months.

       

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

        Hi some_bih ,

        To clarify, the measure's output wasn't behaving as required, so I made the relationship inactive to obtain the last available value per GL. However, the issue is not with the retrieved values themselves, but rather with the totals displayed in the visual.

         

        Thank you in advance for your assistance.