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 

if you want to retriev LASTDATE, try to rework your measure as on link for column "Last date Sales" in example I created.

https://dax.do/0qEUdVul7CvnFj/ 

 

 

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

hello some_bih ,

Unfortunately, it is not working, as I need in the report.

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

    Hi Ezzeldin please share file with example and expected output.

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

      I wanted to attach the Power BI file, but I couldn't find a way to share or attach it to the main question. Can you please guide me on how to share the file?