Project Cost to Date

Used for anything related to the new Power BI Desktop and Service tools
suebasri
Posts: 3
Joined: Sun Dec 17, 2017 10:29 pm

Project Cost to Date

Postby suebasri » Mon Dec 18, 2017 3:06 am

Hi,

Can you show me how to calculate measure for Project Cost by Project To Date (from start date 2015 to say 2017).

I have
1. Year Slicer and
2. YTD Project Cost Card - measure: ( YTD Actual = sum(ProjectCost[ActualYTD])

However I need another card to display the Total Project Cost since start of the Project which has run for 3 years.

What kind for DAX formula do I need for the measure.

Thanks in advance.

jazzista1967
Posts: 9
Joined: Tue Jan 26, 2016 12:17 am

Re: Project Cost to Date

Postby jazzista1967 » Mon Dec 18, 2017 8:51 am

You can use the calculate function like this. Make sure you have a calendar table so you can perform date calculations.


CALCULATE([Total cost],FILTER(ALL('calendartable'),calendartable'[Date]<=MAX(calendartable'[Date])))

suebasri
Posts: 3
Joined: Sun Dec 17, 2017 10:29 pm

Re: Project Cost to Date

Postby suebasri » Mon Dec 18, 2017 1:14 pm

Excellent mate! Thank you so much! Got it :D


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest

cron