Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Current Month and YTD Calculation

I have three tables: Business Calendar, Cost, and Project with sample data and column structure provided below:

 

 

I want to create a measure to calculate monthly cost such that if today is between current month business day and next month business day, then calculate total cost for previous month. For example, today is between March business day, and next month business day, so calculate Feb cost for each project. Also, if I refresh data next month on April business day (and between this day and May business day), the cost should automatically reflect for the month of March. I also want to do the same for YTD. Any helps would be appreciated!

 

2 Replies