Forum Discussion

learning_dax's avatar
learning_dax
Icon for Helper II rankHelper II
4 years ago

YTD TOTALS Comparisons

Hey all, 

I'm trying to compare FISCAL YTD as of this week compared to the FISCAL YTD of last week, basically showing growth rate instead of raw WoW analysis (which I've built a matrix for). For instance, this report should show, fiscally YTD, we've had 50 interviews but last week we had 38, so we've increased by 12 and X%. I've figured out my Fiscal YTD formula which is:

=CALCULATE((COUNT'TABLE1'[INTERVIEW DATE]), 'TABLE1'[INTERVIEW DATE] >= DATE(03,01,2021), 'TABLE1'[INTERVIEW DATE] <= TODAY()))

However, I can't seem to get this same total but for last week, month, etc. to be able to compare WoW/MoM but in fiscal year TOTALS form. Any help or suggestions would be appreciated.

 

Thank you.

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi learning_dax 

    any luck you can provide sample file? Screenshot of the visual along with sample input data will also help

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    One easier way to calculated fiscal YTD is to utilize the second parameter in DATESYTD. E.g. CALCULATE([Measure],DATESYTD('Calendar'[Date],"03/31")) will use 31.3. as the year end date.

    To calculate lastweek value you can create a variable like this: 

    var weeknumLW = WEEKNUM(MAX('Table'[Date]))-1 return

    The you can utilize it for example like this:

    var weeknumLW = WEEKNUM(MAX('Table'[Date]))-1
    return
    CALCULATE([YTD measure],ALL('Table'[Date]),WEEKNUM('Table'[Date])=weeknumLW,)

    I think you can solve you the problem byt utilizing these tricks. Ping me with @ if you have questions/problems.


    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/


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

    Hi learning_dax ,

     

    May I know whether your issue has been resolved? If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it, could you please provide some sample data from your tables and let us know the relationships among them so we can find a solution for you. Thanks in advance!

     

    Best Regards,

    Community Support Team _ Caiyun