Forum Discussion
Help with Timing Issue for Totals
I'm trying to create a comparison of my company's actual financials vs. budgeted vs. proforma forecast. All numbers are reported on a monthly basis and we follow an academic calendar that starts in A...
Hi Xiaoxin,
I couldn't figure out out to upload my files onto this forum, so I've uploaded the to the Dropbox link here:
https://www.dropbox.com/sh/w46j50uwob4k7wi/AADNQqNkY8whh5paI7YGCX5Wa?dl=0
If there is another way I need to get files to you, please let me know. Really appreciate this!
Hi fsy,
I find you have miss the '&' character.
Notice: '&' equal to CONCATENATE function, '&&' means and logic.
Budget YTD = calculate([Budget], FILTER(ALL(DateTable),[DateKey]>=date(2011,1,1)&&[DateKey]<=date(2017,6,1)))
Regards,
Xiaoxin Sheng