Forum Discussion
Column value based on calculation of another column
Hello Everyone, I am looking for some guidance here. I have an attedance share point list. Fromt that i have starting creating a report on Power Bi. i have created a metrix table with rows as we...
so in my SP list I have a following columns and data
Name - Name of employe
Date - Date of entry
WFO/WFH - Choice column with WFH and WFO option
WeekEndingDate - Calculated Column to get Week ending date based on entry date
I added a metrix table to get number of entries in WFO/WFH column corsponding to weekending date , resulting in giving count of WHO and WFH as you see in the screenshot.
Now on bases of number of WFO value i want to make a new column which should be able to filter data based on two slicers - Name and Date of Entry(Only using month) .