The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
80 | |
73 | |
40 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
55 | |
47 | |
47 |