Add column

[MSAYED26]

Hello, 

I want to add condtional  column  to add target value with time period.

[TomMartens]

Hey @MSAYED26 ,

I have no idea what your requirement is. If the screenshot reflects on the expected result, then you also have to describe the source data as well, next to that the rule to create the value for the conditional column is missing. Are you looking for a solution that is creating the column using DAX or Power Query?.

Regards,

Tom

[MSAYED26]

Add a variable column based on a specific time period with power query

[TomMartens]

Hey @MSAYED26 ,

this article describes how you can add a "custom column" using Power Query: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-custom-column

If the article does not help, you have to describe the input, the expected output, and the rule how the value in the new column is derived from the existing data.

Hopefully, this provides some additional information of how to tackle your challenge.

Regards,

Tom