The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
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
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |