Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I want to add condtional column to add target value with time period.
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
Add a variable column based on a specific time period with power query
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
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |