Forum Discussion
create a calculated column for date count under a date slicer
If we have all the absence date for each person, and we have a column that showing the frequency(or count) of the person's absence date with a date slicer. How can I create a calculated column shows "Yes" if the count of frequency is greater than 2 under the date range?
The problem I am having is, the Yes or No column is not controlled by the absence date slicer. For example, if this person has more than 2 absent in the whole data set, the column is showing "Yes" no matter what time range it is.
How can I solve this? Thank you!
Hi hewwo,
You could refer to my sample to see whether this is what you want, if this is not what you want, please correct me and inform me more detailed information(such as your sample data and your expected output).
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
Is something like this not working
if (calculate(sum(absence),all(date[date]))>2,"Yes","No")Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
daxCommunity Support
Hi hewwo,
You could refer to my sample to see whether this is what you want, if this is not what you want, please correct me and inform me more detailed information(such as your sample data and your expected output).
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- dax
Hi hewwo,
According to your description, it seems that you want to create calculated column based on slicer, right? If so, I think you can't achieve this goal, because calculated column can't be controlled by slicer, you need to use measure to achieve this goal.
In addition, did you want to show a column value to " yes" when absent amount>2? If possible, could you please inform me your sample data and expected output? Then I will help you more correctly.
Please do mask sensitive data before uploading.Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
