edX lab 2 lesson 4 and 5

[Anonymous]

Hello. I am trying to learn how to use PowerBI through edX course.

However, I am running into some issues.

In particular, in lesson 4 of chapter 2, I am not able to replicate the results he gets.

When the instructor plots the sales revenue against the month number, he gets the following:

While I get this result:

 

Which is very different.
However I can't understand why this happens.

On a similar note, in lesson 5, when he calculates YTD revenue base on the Date column in the Date table, I get a different result.
Namely, the revenue and YTD revenue measure are the same.

[v-lili6-msft]

HI, @Anonymous

It seems that you don't create the relationship between data table and date table, or the direction is single.

Please check it.

and for TOTALYTD is Time Intelligence Functions, it needs a date table

and create a formula like this YTD = TOTALYTD(SUM('Table'[Sales]), 'Date'[Date])

https://msdn.microsoft.com/en-us/query-bi/dax/time-intelligence-functions-dax

and then drag field date from date table into axis and measure into Value

Please Check the relationship between date table with data table

Best Regards,

Lin

[Anonymous]

Hi,

Thank you for your very useful answer.

It solved my issue.

I have one more question: Is there a quick way to generate a Date table that all the data intelligence functions can use when preparing graphs for report?

[v-lili6-msft · Accepted solution]

hi, @Anonymous

Try to CALENDARAUTO Function to create a date table as below

https://msdn.microsoft.com/en-us/query-bi/dax/calendarauto-function-dax

Best Regards,

Lin