Forum Discussion
2 different dates of different table
Thanks for this solution, but I already had tried this not working for me. It is also giving me 0 against data.
Can you please provide sample data and your dax calculation
- kb2622 years ago
Helper I
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.- PowerBigginer2 years ago
Helper II
I created calendar table using power query method for me it is working in below screenshot I have selected future date range
- kb2622 years ago
Helper I
This my schema, when I create relation between these, I have to inactive relation between task and client_journey however, this is an important relation.
and in result it is giving me 0/blank.