Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help in formulating a column

Hello Experts, I am new to powerbi and would appreciate your help. I have a sample data as below: ID Date 1 15-09-19 1 20-10-19 2 10-08-19 2 23-11-19 3 29-11-19 3 15-12...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    The formula az38  created is a measure.

     

    If you want a calculated column, you can do like this:

    Column = 
VAR x = 
CALCULATE(
    MAX([Date]),
    ALLEXCEPT(
        Sheet1,
        Sheet1[ID]
    )
)
RETURN
IF(
    [Date] = x,
    "T", "F"
)

     

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

The formula az38  created is a measure.

 

If you want a calculated column, you can do like this:

Column = 
VAR x = 
CALCULATE(
    MAX([Date]),
    ALLEXCEPT(
        Sheet1,
        Sheet1[ID]
    )
)
RETURN
IF(
    [Date] = x,
    "T", "F"
)

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks a lot to you both v-lionel-msft  and az38  for your help and replies.
Feel happy to be part of this community.
Keep up the good work guys!