datediff

[dida]

[FONT=&quot] I Have one table of calendar in the query simply dates. another table of projects and start date of the projects.[/FONT]
[FONT=&quot]I wish to choose the project and then get in the calendar table another columns that compare the chosen project start date to the date in the calendar/ I could not find any way to do it. date diff doesn't not work with chosen from slicer[/FONT]

PROJ	date
A	13/01/2016
B	19/01/2016
C	04/01/2016

<tbody>
</tbody>

[FONT=&quot] [/FONT]

date	date diff from project
01/01/2016
02/01/2016
03/01/2016
04/01/2016
05/01/2016
06/01/2016
07/01/2016
08/01/2016
09/01/2016
10/01/2016
11/01/2016
12/01/2016

<tbody>
</tbody>

 

[sandy666]

edit queries
on the left you'll see two tables, on the right Applied Steps
choose first table and see steps
edit Added Custom (little gear, and you'll see what I did)
check each step so you will see the whole way how it was done.

for datediff
select column date (as first) and date.1 (as second) then use from the ribbon: Add column - Date - Subtract Days

slicer is just a filter , nothing more so add slicer and select column with PROJ (A, B, C)

I cannot say too much about MDX because I don't use PowerBI often (I can say: very rare )

 

[dida]

I did it all. but once I add project to the source database and tried to refresh I could not is that the way it works in power query?
secondly it looks that date diff looks good in the query but in the table its not...
I wish I could add attachment
I used to do all in MDX

 

[sandy666]

• Getting started with Power BI Desktop
• Power BI Guided Learning
• Power BI Tutorial
• Power BI Tips and Tricks
• ...and much more on Google