How to combine dates (Year,Month,Quartal) in one Measure with different sources?

[SvenMaassen]

Hello Together,

i hope someone of you could help me 😃

Is it possible to combine mutiple rows from differen Excel- Sources ??

I would like to combine the date from several sources in one. The background is that I want to make a graphic for each source but all change as soon as you change something on the timeline.

Greeting Sven 😃

[SvenMaassen]

Hello Together,

i hope someone of you could help me 😃

Is it possible to combine mutiple rows from differen Excel- Sources ??

I would like to combine the date from several sources in one. The background is that I want to make a graphic for each source but all change as soon as you change something on the timeline.

Greeting Sven 😃

[MarcoG2000 · Accepted solution]

You need to create a date table, a dimension table (DimDates).

Link the DateKey of this table with the date field of the other tables. Use Datekey to filter all the tables at once.

There are several ways to create a date table. Logically the best is in M. Anyway I'll pass this link.

http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

Marco G

[MarcoG2000]

Hi SvenMaassen, the request is a bit vague.
If you can kindly insert some more data or an example of the current situation and the desired one.

Marco

[SvenMaassen]

Hey Marco,

sure no problem!

i have these 3 Excel Sources

Now i want to get just One Timeline where every Graph changes. BEcause every Source have an row with Dates. And for example want to see how each "Graph/Source" was last year.

I dont want to make several timelines for that 😄