Forum Discussion
Helper IFilter table based on calculated measure from another Table
Hello, i have two tables one table called "Orders" contains following Columns:
Productnumber, Orderdate
And the other Table "Time" that contains only Dates from 01/01/2019 until 31/12/2021. In the Time have an calculated measure where i want to display the min(date)-6 months from the selected Filter.
Now i would like to create a new column in the Table "Orders" where minDate <= Orderdate gives me True or False back.
This function doesnt seem to work.
Includes = IF(RELATED(Time[minDate] <= 'Orders'[Orderdate]),TRUE,FALSE)
Has anyone an idea?
Thanks in advance
Krexx , You can not create a calculated column on the slicer . Assume the two are related. You can get all dates/order below the selected date
measure =
var _min = minx(Date, Date[Date])
return
calculate(Count('Orders'[Orderdate]), filter(All(Date),Date[Date] <_min))
2 Replies
- amitchandak
Super User
Krexx , You can not create a calculated column on the slicer . Assume the two are related. You can get all dates/order below the selected date
measure =
var _min = minx(Date, Date[Date])
return
calculate(Count('Orders'[Orderdate]), filter(All(Date),Date[Date] <_min)) - Greg_Deckler
Community Champion
Krexx - You cannot create a column in a table that dynamically updates based on a measure if that is what you are trying to do. If I read this correctly, you are trying to do something like a Complex Selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
@ me if none of this is correct or doesn't help. Sample data and expected output would help tremendously in that case.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
