Forum Discussion

stxreporting's avatar
stxreporting
Frequent Visitor
4 years ago

Time intelligence not returning correct value

Hi,   I'm using a dateadd function that calculates the previous period's value using a separate date table.   It was brought to my attention by a user that the values for 2020 are not correct. I ...
Need Help
stxreporting's avatar
stxreporting
Frequent Visitor
4 years ago

Hi,

 

I do not have month year in my visual, just the measures for current year and for passed year (the one I sent above). I don't see how the solution you proposed will return anything other than blank(), since the max('date'[date]') will by definition always be bigger than _max right?

Could you please elaborate?

Thanks,

 

Chris

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, stxreporting 

Please try formula like:

Result=
 Calculate([some measure],DATEADD('Date'[Date],-1,YEAR),'Table'[Monthnumber]<currentYearMaxMonth)

or apply a filter measure to table visual filter pane.

Best Regards,
Community Support Team _ Easonl

  • stxreporting's avatar
    stxreporting
    Frequent Visitor
    4 years ago

    Hi v-easonf-msft,

     

    thanks for your reply but this doesn't seem to change anything?

    Could you please elaborate what this part of your solution does?

    'Table'[Monthnumber]<currentYearMaxMonth

     

    how I see it that would still not be able to retrieve the days passed this month so far?

    Please let me know,

     

    Chris