Forum Discussion
2 different dates of different table
In my powerbi report I am showing Client Register count which is coming from client_journey table and for this I am using created_at date column from client_journey table, in this table I have maximum dates till current date, similarly I am showing the count of meetings from task table and for this I am using start date of task table and in this start date column there are dates for future days as well, I have sync these dates (created_at and start date) and when I select any future date it gives me 0 or blank data, however i have data in task table.
Suggest the solution please.
11 Replies
- PowerBigginer
Helper II
Create a calendar dimention table and give relationship from calendar table to your table
To create calendar table using DAX follow below link
https://powertipstricks.blogspot.com/2024/01/create-calendar-table-in-power-bi-using.html
To create calendar table using power query follow below link
https://powertipstricks.blogspot.com/2024/01/create-calendar-table-with-power-query.html
If it helps Mark as a solution!
Thanks & Regards- kb262
Helper I
Thanks for this solution, but I already had tried this not working for me. It is also giving me 0 against data.
- PowerBigginer
Helper II
Can you please provide sample data and your dax calculation