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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

stxreporting , That will happen if you use month year in visual, in that case it is getting complete month dates

 

 

Try like

forced=
var _max = date(year(today())-1,month(today()),day(today()))
return
if(max('Date'[Date])<=_max, Calculate([some measure],DATEADD('Date'[Date],-1,YEAR)), blank())
//or
//calculate(Calculate([some measure],DATEADD('Date'[Date],-1,YEAR)),filter('Date','Date'[Date]<=_max))

 

  • 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