Creating measure to-date

[Anonymous]

Hi, 

I am wanting to only show a count to-date.. This current table and graph is comparing this year's to-date number to the complete last year total (making it look like we are way under: 

Here are the measures creating the values:

% Conversion Rate = [Funded Sales]/[Written Sales]

Written Sales = CALCULATE(SUM(Facts[MetricValue]), Facts[MetricName] = "WrittenSales")

Funded Sales = CALCULATE(SUM(Facts[MetricValue]), Facts[MetricName] = "FundedSales")

Any help?

[Ashish_Mathur · Accepted solution]

Hi,

Use the function SAMEPERIODLASTYEAR() function.  Remove years from your visuals and place them in a filter/slicer.  Select 2017 in the filter/slicer.  Use this measure

% conversion rate LY = CALCULATE([% conversion rate],SAMEPERIODLASTYEAR(Calendar[Date]))

I am assuming that you have a calendar table which has running dates.  In that calendar table, extract month and year in 2 spare columns.  Create a relatioship from the Date column of your source data table to the date column of your calendar table.  In the filter/slicer, drag the year from the calendar table.

[srinivt]

Have you tried the Year-To-Date quick measure? Here is a link that provides some documentation: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/