Forum Discussion
Solved
Tag a record
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
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,
9 Replies
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,
