Forum Discussion
ytd
Hi Katerina_Bis,
When you added measures *YTD_turnover amd *YTD_timelog to a table visual, which error threw out? Please try to set the cross filtering direction to Both for each relationship among those tables. For more information, see: Create and manage relationships in Power BI Desktop.
Best Regards,
QiuyunYu
Hello,
I cannot share the data sample. But I have drafted the data structure and the desirable result.
Hope it helps.
data_structure
Hi Katerina_Bis,
I think you should have one more Dates table for both of Finance_data and JIRA_Data as side-by-side topic and you could use date column of that Dates table for slicer.(Finance and JIRA will refer date column of new DATES table)
One more concern that *YTD_turnover and *YTD_timelog are default columns from sources or calculated measures? if they are calculated measure that computed by DATE_FIN and DATE_LOG, you need to adjust formula to compute by new Dates table.
Hello @tringuyenminh92,
I have added extra date table DATE_COMMON and created "Many to One (*:1) relationship between date in DATE_COMMON and Finance_data and another "Many to One (*:1) relationship between date in DATE_COMMON and Jira_data.
One of the relationship is NOT active - dashed line between fields.
Here is the error message I get when trying to tick the box "Make this relantionship active":
(note : StExportAll = Finance_data)
YTD values are calculated measures, calculated accordingly on 2 date tables, for each type of data: Finance and Jira.
Hi Katerina_Bis,
It's correct. you need to choose one active and another inactive in this case. And for some aggregation in DAX, you could use userelationship() method to access inactive relationship for computing.