Need 1 date to filter

[ramie]

Hi Everyone,

i have a problem with different dates , i am unable to fix those , need community help.

The scenario is , i have  more that 5 dates available in one table, other tables not important. But in that 1 table i have 5 different dates , i have used  one date for finding employee of the  month and year as well , i have completed calulation part here, but i need to count some codes which falls under other date range , so i need only one date column or table filterall the data in the report.

is there any solution.

I have created date table also , but realtionship problem, in past i have created measures and all on basis of one date column , now i tried to creating relationship using that column , getting error ,

one relatioship is fine which is woend date column to dim date column and another is xtradate01 to date getting error in measure level becaues i established a relationship from xtradate01 to date , immediately error is getting

How can i fix all these in one shot , any solution or way to solve this

Your Efforts will be much appriciated

Thanks in Advance

[amitchandak]

@ramie , You can try a single date table with inactive joins and userelationships

example

calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date]))

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[ramie]

Hi @amitchandak 

i have created a measure using userelationship with inactive joins, but like i mentioned above , this error  i am getting , formula giving error

if i create a relationship between xtradate1 column to date column , with an in active relationship , above formula showing error , other wise i can use userelationship or crossfilter also if need.

Doubt : After creating inactive relationship is dim date table able to filter both dates underlying informations with only dim date slicer selection. i don't want multiple date slicers in my report to filter data, 1 date slicer need to filter all the data in report.

Please let me know any suggestions

Thanks