Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter visual using related table

I have two tables, one is a calendar and the other is a list of job posting details. I am calculating the date a job posts is over a certain age, then using the calendar can make a trend chart showin...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

 

NickolajJessen is right, disciplined modeling is the beginning of everything good. 

I changed the calculated column to measure and created slicer and filter, please check the PBIX file.

The PBIX file is attached for reference.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for this however this captures the static date an even happens, whereas I'm trying to capture daily records over a period of time, a position that ages on 1/5/22 and closes on 6/5/22 would be counted on the 1st, 2nd, 3rd, 4th, 5th and 6th of the month. Upon reflection I see the question didn't outline this particularly clearly.