Forum Discussion

Vladracs's avatar
Vladracs
Icon for Helper I rankHelper I
3 years ago
Solved

Help troubleshoot DAX measure

Hello Experts,   Trying to understand how is it possible to get a wrong value (2x the actual value) just for 1 month (dezember) and 1 year (2018) in the example below: Where the formula for Ulti...
Need Help
  • Vladracs's avatar
    Vladracs
    3 years ago

    sorry to bother you guys! there was a duplicate file in the folder I havent noticed . ignore this one

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Vladracs ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

Vladracs's avatar
Vladracs
Icon for Helper I rankHelper I
3 years ago

Hello,

As you can see I am trying to display the last available data within a time frame. using 
CALCULATE (
SUM ( 'FACT-TABLE'[VALUE] ),
LASTDATE ( 'FACT-TABLE'[DATE] )
)
It works for pretty much all data set, but for the month of Dec 2018.

If you look at the screenshot, you see that I just put a table with both value at the month and the calculated value showing the last value (which in this case would be the same month) - note that I will apply this to a quarter or year later.

anyway, the point is the month value and the last data in the month value are the same! so there's no explanation of why 2018 is showing the value x2.