topic Re: Different facts at different times in one dashboard in DAX Commands and Tips

Different facts at different times in one dashboard

adminclikalia — Mon, 21 Jun 2021 16:04:22 GMT

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.

Re: Different facts at different times in one dashboard

selimovd — Mon, 21 Jun 2021 20:03:22 GMT

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

Re: Different facts at different times in one dashboard

adminclikalia — Tue, 22 Jun 2021 08:54:55 GMT

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