Used for anything related to the new Power BI Desktop and Service tools
2 posts • Page 1 of 1
I want to populate each row of this table (NumDays) with the count of rows from this table that have the value of KEY1. I have this working by extrapolating the data from an additional table we added but I'd like to not have to do that. How do I do this?
- Adding Column.docx
- (38.84 KiB) Downloaded 49 times
Assuming your data table is called "NumDays", which is what I understand from your description, and that you want the frequency (count) of each value appearing in the column labelled "KEY1", which is again what I understand from your description, you can get this count in a calculated column, by writing
Who is online
Users browsing this forum: No registered users and 0 guests