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.
Can someone help me on how to tag a record in power bi query using filter.
Ex:
count records if order date <= calendar and delivery date is > calendar - tag the record late delivery and so on
thanks
Solved! Go to Solution.
Hi @CJ_96601 ,
There is a problem. If you' like a column in Power Query, you have to assign the date to use. In other words, you can't make it dynamic. Since you need a column, there could be two solutions.
1. A calculated column with DAX.
test = IF ( 'sales'[order date] <= TODAY () && 'sales'[delivery date] > TODAY (), "Late Delivery", "Normal" )
2. A new column with Power Query.
if [order date] <= DateTime.LocalNow() and [delivery Date] > DateTime.LocalNow()
then "Late Delivery"
else "Normal"
Best Regards,
Hi @CJ_96601 ,
If you'd like to show them in a report, please try out this measure.
test = IF ( MIN ( 'sales'[order date] ) <= TODAY () && MIN ( 'sales'[delivery date] ) > TODAY (), "Late Delivery", "Normal" )
Best Regards,
Hi, thanks.
Instead of today, i need to have a variable date, in filter.
Regards,
Obet
Hi Obet,
You can try this one in that case.
test = VAR selectedDate = IF ( ISBLANK ( SELECTEDVALUE ( 'Calendar'[Date] ) ), TODAY (), SELECTEDVALUE ( 'Calendar'[Date] ) ) RETURN IF ( MIN ( 'sales'[order date] ) <= selectedDate && MIN ( 'sales'[delivery date] ) > selectedDate, "Late Delivery", "Normal" )
Best Regards,
Thanks. can i use power query or measure?
Hi @CJ_96601 ,
Could you please mark the proper answers as solutions?
Best Regards,
Hi, thanks, but it is not the solution i am looking for.
I need the tag in additional column, in power query
regards,
Hi @CJ_96601 ,
There is a problem. If you' like a column in Power Query, you have to assign the date to use. In other words, you can't make it dynamic. Since you need a column, there could be two solutions.
1. A calculated column with DAX.
test = IF ( 'sales'[order date] <= TODAY () && 'sales'[delivery date] > TODAY (), "Late Delivery", "Normal" )
2. A new column with Power Query.
if [order date] <= DateTime.LocalNow() and [delivery Date] > DateTime.LocalNow()
then "Late Delivery"
else "Normal"
Best Regards,
Thanks.
My pleasure. It's a measure.
Best Regards,
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |