Forum Discussion

IsaLe's avatar
IsaLe
Regular Visitor
7 years ago
Solved

solution for the First time name and has targeted value

Hi, I am struggling with this!!!my ideal is create a table of NAME that appear only one time in the merge table, then check if it has value =10. Bingo!!! Unfortunately, i have not succeeded. please h...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi IsaLe 

    Is this problem sloved? 

    If it is sloved, could you kindly accept it as a solution to close this case?

    If not, please let me know.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi IsaLe 

I make a test as below:

Table 1 and Table 2 

Create such relationship

In Table1, create a calcuated column with formula

Week = WEEKNUM([date],2)

Then in Table2, create a measure

Measure = var minvalue=CALCULATE(MIN(Table1[Week]),ALLEXCEPT(Table2,Table2[product])) return IF(minvalue=10,minvalue,BLANK())

Add column and measure in a table visual

If your scenario is different, please show me example data for analysis.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.