YTD TOTALS Comparisons

[learning_dax]

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.

[v-cazheng-msft]

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

[ValtteriN]

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/

[tamerj1]

Hi @learning_dax 

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