Exam 70-779 topic 1 question 41 discussion

b IS CORRECT

I tried C but the given number format couldnt be transformed to a date format .. So i go with B

C can work if you do the following: 1: Navigate to Power Query for the table 2: Change the date column type to Text. 3: Change the date column type to Date. Note: In case you have zero-values in your data (00000000), replace the 00000000 values with blank values, i.e. leave empty (this can be done in Transform tab --> Replace Values)

Infinitive ans is C : it's not recommand to use a calculated column with DAX, for optimisation you can can transform the column dateID to a date type: Date.FromText(Text.From([colone]))

correct answer is B

I have to say, both B + C correct.(both Tested) 1. in Data Model, add a DAX calculated column(not measure) in Date Table(not in invoice Table): =FORMAT(DateFormat[Date], "mm/dd/yyyy"); 2. in PQ Editor, also Date Table into Query, change typr from "whole#" --> "Text" --> "Date".

I have to say, both B + C correct.(both Tested) 1. in Data Model, add a DAX calculated column: =FORMAT(DateFormat[Date], "mm/dd/yyyy"); 2. in PQ Editor, [dateID], change typr from "whole#" --> "Text" --> "Date".

C, tested. 1. Import into PQ editor, Step1. Change “YYYYMMDD” to format “text”. Step2. Change “text” to “Date” 2. Load to data model to replace original table “Date”. 3. Create relationship between PQ exported “Date” & “invoiced” in Data Model View under “diagram View”.

It is C. The first step is to convert ISO date into text data type, and then from text to insert a new step and change to the date data type. it is important to accept inserting a new step.

I would say C, but in PQ

My Excel even lets me create a working relationship between the Date[DateID] in WholeNumber format and the Invoices[DateID] in Date format - so I don't have to do any re-formatting ?!?

B. Tested!

It's a very common situation when a date is input as an 8-digit number like 10032016, and you need to convert it into a date value that Excel can recognize (10/03/2016). In this case, simply changing the cell format to Date won't work - you will get ########## as the result. To convert such a number to date, you will have to use the DATE function in combination with RIGHT, LEFT and MID functions. https://www.ablebits.com/office-addins-blog/2015/03/26/excel-convert-text-date/

I'm very surprice that "A" worked, sinced the formats of the dates were different for each table.

I just try B and that also worked.

As amazing as this might sound to all of you. After not being able to replicate (validate) C, which seems to be the correct answer. I tried A, and it worked as a charm. . . Go figure! ! the answer is not C, because the excel won't let you change the data type whole number to Date when the format in the DATEID field is YYYYMMDD.

B is correct. Here the formula would be FORMAT(Invoices[InvoiceDate];"YYYYMMDD"). You can then link both tables on two columns with the same format YYYYMMDD.