Different facts at different times in one dashboard

[adminclikalia]

Ey guys, thank for your time. 

I have a trouble in the visual I´m working on.  What I need to do is to count different facts like:

- count the number of leads,

- count the number of properties valuated,

- count the number of visits

- count the number of deals closed, and so on.

The problem is that  those calculated measures are in diffferent dates and in different tables and they need to be related to my calendar table. How can I put all of these in one single visual? Looking forward to your answer.

thank you.

[selimovd]

Hey @adminclikalia ,

you should create a date table and use that in your visuals.

As all the other tables then have a connection to the date table, they all should show a proper result. Take a look on how to create a date table:

https://softcrylic.com/blogs/power-bi-for-beginners-how-to-create-a-date-table-in-power-bi/

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[adminclikalia]

Thank you Denis. One more question here.

I made the table date to relate the facts with this table but the thing is that all are combined by the create date but I need to merge also by other dates like the visit date or the date where the offer was approbed by the client. How can I do this? I created a new relationship of these dates with my table date but I can´t finish my query. 

Sorry if my english is not perfect. I´m spanish.

Thank again for your time.

Regards