Choose data versions to compare aginst

[Anonymous]

Hi,

I have a master dataset that gets automatically updated and is more or less in the following format:

Upload Date - Country - Value

The uploads happen now and then in quite ambiguous intervals. In my measurement, I would like to calculate the growth percentage of the value between two upload chosen upload dates. 

E.g. Choose that I would like to get the growth rate of 01-01-2019 version against 04-02-2019 version. Ideally, I would like to have filters where I could choose which upload version to compare against another chosen upload version.

Any help will be greatly appriciated!

[tarunsingla]

You would need 2 different measures to capture the 2 dates of report viewer's choice (selection dates from the two slicers).

And then use those 2 selected dates values in a calculated measure to lookup the values and then compute the growth.

Something like:

Growth = 

var fromDate = SELECTEDVALUE(date1Field) // or MIN(dateField)

var toDate = SELECTEDVALUE(date2Field) // or MAX(dateField)

RETURN DIVIDE(LOOKUPVALUE(valueField, dateField, fromDate), LOOKUPVALUE(valueField, dateField, toDate))

Hope this helps.

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490