Forum Discussion

slothman's avatar
slothman
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Custom column or measure

Hello all,   I need help with a custom column or maybe a measure with the following logic: Basically I have a table with categories and some values around them (Date column) where not all rows hav...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if the below solution is the best way to approach, but please check the below picture and the attached pbix file. I tried to use PATH function and PATHITEM function to create the Outcome Wanted Calculated Column.

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if the below solution is the best way to approach, but please check the below picture and the attached pbix file. I tried to use PATH function and PATHITEM function to create the Outcome Wanted Calculated Column.

 

  • slothman's avatar
    slothman
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Thank you very much, this works great!