One date filter for Three date columns

[Muratik55]

Hello,

I have a store procedure that contains three date column and those column are refering to created date,activity date and completed date

i would like to get in last 1 week calendar filter. but the problem is if i select above date column i don't get result for other date column values.
So i created a calendar table and i created a relationship between those three columns with the calendar table but the issue with that when use calendar date for prior calendar week filter i lost data in my table visual. (calendar table startdate is begining of this year)


Is there any way to create a calendar column in my table in power bi or is there any way to have  one date filter that runs for those three date column that i have.

Thank you

[Muratik55]

Yes it helped and i don't lose data when i filter it but now the problem is it started triples the values everytime. because for example i am working on tickets dashboard. so some tickets are open and had worked on and after that closed in that time period. now instead of showing it in different column it just triples the value for that day

[Ashish_Mathur]

Hi,

That can be reolved with a measure.  On a small dataset show the exact result you are expecting.  Paste that in a format that can be pasted in an MS Excel file.

[Ashish_Mathur]

Hi,

In the Query Editor, select all columns other than the 3 date columns, right click and click on "Unpivot Other columns".  Rename the Value column as Date.  Does this work?