EDNA tutorial lectures

DAX DAX Calculations
1

HI @sam.mckay

Was going through your lecture on Scenario sequencing. The link is as follows:
Scenario sequencing - maintain a table of scenarios and integrate all values | Enterprise DNA

There are a couple of things that are not clear to me.

Firstly, the measure’2018 scenario sequence’ reflects the Scenario profits for the FInancial Year 2017 (hence the filter), but only after they have been subject to chnages in demand, price etc. Why was there a need to add the DATEDD function in the measure then? Wouldnt just filtering by 2017 be sufficient?

Secondly, why did you subject the 2017 profits to 5 percent increase when there is already the option of increasing prices through pricing scenarios value?

2

Hello all! Bumping this post for more visibility.

3

Hi @musa.fasih

I have recreated the formula with my sample Data and tested for different combination. Please find response below.

  1. Scenario 1 (No DATEADD function) - If there is no DateAdd function as shown in measure below , data will show Total sales for year 2015 for all Dates in visual.

Scenario Sales 2016 only Filter = CALCULATE([Total Sales],filter(all(Dates),Dates[Year] = "2015"))

image

  1. Scenario 2 (No Filter function) - If there is no Filter function, Data will show Total sales for all Dates for previous year.

image

  1. Using both filter and DateAdd function. Filter will ensure Data is limited to year 2015 only and DateAdd will ensure previous year value is calculated . So using both combination will give Sales for 2015 for Dates in 2016.

Scenario Sales 2016 = CALCULATE([Total Sales],filter(all(Dates),Dates[Year] = “2015”),DATEADD(Dates[Date],-1,YEAR))

Hope this is clear and can be tested using Sample data.

Regarding 2nd query, yes pricing scenarios value could have been used and shown.

Thanks
Ankit J

4

Hi @musa.faith, did the response provided by @ankit help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

5

Yes, thanks @ankit !