Forum Discussion
Extract Number of Rows per Bracket
Hello
how could I count the rows for each section, Visit, Email and Outbound? Then I would also like the same but that it changes according to the date filter that I put on it and also another one that tells me the amount but 1 year before the selected date.
Here's the table:
Thank you.
I suggest you do some basic research on how to use Power BI - difference between Measures and Calculated Columns and how to use them.
3 Replies
I suggest you do some basic research on how to use Power BI - difference between Measures and Calculated Columns and how to use them.
Syndicate_Admin you probably mean that you want to calculate a measure for a visual, correct?
1) create a visual, e.g. table, where you put Interaction Template to Code as a first row, then add it as a second row as well, however, click on the field with your right button and select "Count".For values calculated 1 year before refer to this: https://community.fabric.microsoft.com/t5/Desktop/Value-a-year-ago/td-p/1227776
In short you need to create a date table and create a measure that uses CALCULATE and DATEADD.
I already have a calendar table and as you say, I did get the table view with the count. What I don't quite understand is how to make the measurement so that it calculates the number of Visits both for the selected date and for the previous year.
