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
v-easonf-msft's avatar
v-easonf-msft
Community 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