Forum Discussion
Helper I2 different dates of different table
Helper IICreate 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
Helper IThanks for this solution, but I already had tried this not working for me. It is also giving me 0 against data.
- PowerBigginer
Can you please provide sample data and your dax calculation
- kb262
I am using created_at date from this and count of these ids so, for selected data I must have 4 counts which works fine when I select 3/11/2024 date.
(Note: In this table my data increase with the current date, so there's no future date data like data for tommorrow on for this week etc )
But, with this I have to show meeting count from task table and I am using this start date from task table, in my powerbi report I have synced these both date filters;as you can see against user id 1, I have this data but the start date is different, Now when I select any future date, it in result gives me 0 for meeting count.
And, when I create calendar table, I am unable to active relation between bith these tables in 1 time.- PowerBigginer
I created calendar table using power query method for me it is working in below screenshot I have selected future date range