Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I had a query which was resolved and functioning, whereby the 'End Date' field was no greater than the Parameter start date.
https://community.powerbi.com/t5/Desktop/Running-Measure-filter/m-p/1255365#M553100
This however, when creating a relationship with the New End Date and Parameter end date, messed up measures I had in place. I was just wondering if somebody could help me with this problem ,where it wouldnt show a row that has an end date greater than the Param start date and not have the relationship to the parameter start date mess up other data in that table. Would it require a third date table possibly?
Thanks
@Anonymous , You can have active , inactive join. And use userelation with one date table. Also, you can use crossfilter to remove join and creat join of your choice.
The current employee is an example in this blog where join with start date has been removed
You can have independent table if needed
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |