cancel
Showing results for
Did you mean:
Frequent Visitor

11 REPLIES 11
Regular Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

Hi,

Hope you are formating the second measure to be created in ex 2 as percentage . you require to take out the sales var here. and then derive the  % for the same .you can also share the formula you are using for the same if you are trying somethig else.As, answer to this question is coming out to be correct.

Frequent Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

I am getting the same answer of -31.92%... Did you ever figure this out?

Frequent Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

Nevermind- it's just because of the way you're visualizing it in the report. I was doing it the same way they did it in the tutorial where Sales Var% is on the y-axis and years below. Instead just drag sales var % onto your report and click the "table" option to visualize. You should get 2.74% now

Frequent Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

Are you saying 2.74 is the correct answer ? If so can you please share the DAX formula ? because I am getting -49.76 for the question What is the figure for the YTD Sales Var % measure? (enter the absolute value, to two decimal places) which is incorrect.

Highlighted
Frequent Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

Are you saying 2.74 is the correct answer ? If so can you please share the DAX formula ? because I am getting -49.76 for the question What is the figure for the YTD Sales Var % measure? (enter the absolute value, to two decimal places) which is incorrect.

-49.76% is correct, but the question is asking for Absolute Value, which is 49.76!

Regards

Frequent Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

Awesome! I got that right, thanks for the response.

New Member

## Re: Lab 2 Exercise 2 and Exercise 3

Hi, I got the same answer -49.76%, but didn't understand what they meant by ABSOLUTE, so did some Google and came across this post. I plugged in 49.76 and it's still not accepting it as the correct answer. I am down to the last strike. Am I suppose to put the % sign too?

Frequent Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

@usaeed01- you got it right. There's a bug on this question. Absolute means to convert the number into a positive value.

Apparently if you enter 49.76%, it'll be right. See below.

As you can see, I failed!

Frequent Visitor

## Re: Lab 2 Exercise 2 and Exercise 3

I had the same problem!! I got 0 for the question even though I had the correct answer. In the previous exercise you didn't have to put the percentage to get a correct answer though. Very annoying