Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am facing an issue with calculated column.
This is sample data and here I want to achieve if isStoreClosed is Closed Status then I want to divide the Daily_Split Value by 6 and add this average value to the next 6 Retail Dates Daily_Split Value.
I have created the Daily_Split2 Column and written the folloing dax to achieve the result
@lbendlin I have got the DAX part and the problem is solved now. Thanks for your message.
Next six days from what? The row context? The "current" date (whatever that is)? Is your data source in import mode?
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |