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
could someone help me with custom column ?
i have a table let say "Product Rules" with ProductID,Productname, effective_date, Expiry_date
something like this:
All i need is ,
little more explaintion if need: since Expiry_date 12/31/2018 have only for 4 ProductID. and theoretically Product from 2009 are effective till 12/31/2018 from 1/1/2019 is in effective or expired. and product from 1/1/2019.......... are all Effective they don't have Expiry_date.
any help will abe much appreciated.
Thanks.
Solved! Go to Solution.
Hi @dax ,
Thanks for the quick response.
i think i was not clear before but i want to display both blanks and expirydate in Expiry_date column, when user select any dates between jan 2009 to dec2018. similarly when user select any date from jan 2019- dec2019 or 2020 going forward it should show only 2019 with blanks in Exipry_date column because products from 2019 are all Effective since no Expirydate in Expiry_date column.
since i don't see option for me to drop my file, i can just post screen shots.
when user select any dates between jan2019 to dec2019 or 2020:
when user select any dates between 2009-2018:
not this: not to show all dates like this below screenshot in estimated dates ignoring the filter condition.
we need to display in single table .
i hope i made it clear.
Thanks.
Hi @harip1 ,
Because when you use blank(), it will automatically be ignored, so you could try to replace it with " ". You could try below measure to see whether it work or not.
Measure = if( MIN('Table'[expiry_date])=BLANK()," ",if( MIN('Table'[expiry_date])>=MAX('calendar'[Date]) , MIN('Table'[expiry_date]),BLANK()))
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @harip1 ,
You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dax ,
Thanks for the quick response.
i think i was not clear before but i want to display both blanks and expirydate in Expiry_date column, when user select any dates between jan 2009 to dec2018. similarly when user select any date from jan 2019- dec2019 or 2020 going forward it should show only 2019 with blanks in Exipry_date column because products from 2019 are all Effective since no Expirydate in Expiry_date column.
since i don't see option for me to drop my file, i can just post screen shots.
when user select any dates between jan2019 to dec2019 or 2020:
when user select any dates between 2009-2018:
not this: not to show all dates like this below screenshot in estimated dates ignoring the filter condition.
we need to display in single table .
i hope i made it clear.
Thanks.
Hi @harip1 ,
Because when you use blank(), it will automatically be ignored, so you could try to replace it with " ". You could try below measure to see whether it work or not.
Measure = if( MIN('Table'[expiry_date])=BLANK()," ",if( MIN('Table'[expiry_date])>=MAX('calendar'[Date]) , MIN('Table'[expiry_date]),BLANK()))
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.