About HoaHi

HoaHi · 07-29-2022

Today, I used Intersect() function for comparing 2 column with type "Enumlist" but it error. Before, it worked well. Do you know what happen with this function?This is table that will be filter base on Tag columnThis is Table that i using to filterTh...

HoaHi · 07-12-2022

Hi All,I have a problem after creating a pdf file with Date. In the template, i using TEXT([Date],"ddd, dd.mmm.yyyy") and i want the result will be in English format like: Mon, 04.Jul.2022. But it display in my language: T2, 04.Thg4.2022. I try chang...

HoaHi · 07-30-2022

COUNT(INTERSECT([Tag], SPLIT(ANY(Filter[Tag])," , ")))>0Thanks for your formula. It worked. That mean any(filter[Tag]) return a text -equivalent: CONCATNATE([Tag]) at first row of table. Right?

HoaHi · 07-29-2022

Thanks for your answer. I will try your idea.

HoaHi · 07-29-2022

I know your mean. But i want you know cause [Tag] is "enumlist" type so [Tag] in a row (not entire column) also a list. I just want to know why intersect() not receive "enumlist" for arguments. I remember it worked well before.Ps: i try to use IN([Ta...

HoaHi · 07-29-2022

I want to find in [Tag] on table Filter at least one item that also in the column [Tag] in table Notebook. I intend use formula:COUNT(INTERSECT([Tag],any(Filter[Tag])))>0 to Slice for table Notebook.

HoaHi · 07-29-2022

You can see both of column [Tag] in 2 table is "enumlist" type. Because table Filter only has 1 row. So i use any(..) to pick this row.

My Stats

arunkumarantroi's Bio

Badges HoaHi Earned

Recent Activity

What is happening with Intersect() function?

How to change DateFormat when using Text([Date],"ddd, dd.mmm.yyyy")

Re: What is happening with Intersect() function?

Re: What is happening with Intersect() function?

Re: What is happening with Intersect() function?

Re: What is happening with Intersect() function?

Re: What is happening with Intersect() function?