Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
11 months ago
Solved

Assigning values in a new column based on dates

Hi, I need a new column that assigns an entry per property based on dates.   In this scenario, I have 2 properties that need gas checks conducted every year per each property. When we reach the exp...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    11 months ago

    Thankyou, mh2587, for your response.

    Hi RichOB,

    We appreciate your enquiry submitted via the Microsoft Fabric Community Forum.

    Based on my understanding of the situation, please find attached a screenshot and a sample .pbix file that may help resolve the issue:


    We hope the information provided is useful. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

    Thank you.

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
11 months ago

Hi mh2587 thank so much for such a detailed reply. 

 

The more I think of this, it needs to be split into 2 measures. 

 

1st measure  - for the Completed On Target, Completed Outside Target, Not Completed

2nd measure -for Current, Not Current

 

If a property has a status of Current, it won't show if it was Completed In Target or Outside of target, so we'd be missing that data for the most recent check for every property. I'll accept this as a solution and re-post another one with that info. Thanks again.