Forum Discussion
countrows YTD
Hello, I'm very new to powerbi and to this forum. My apologies upfront if I place this in the wrong section or if the question has been answered already. Even with the help of likewise posted mes...
Hi,
I would suggest the following:
- Append both mail datasets into a single one
- Create a relationship from the Date column appearing in the appended dataset to the date column in your Calendar Table
- In your visual drag Months from the Calendar Table to the X - axis
- Drag the Year (from the Calendar Table) to the slicer and select any one year
- Write this measure
=CALCULATE(COUNTROWS(Data),DATESYTD(Calendar[Date]))
Hope this helps.
Hello guys,
thanks for your patience and helps.
I have copied the URL from my onedrive below. I have combined the 2017 and 2018 mails into a single table.
Ashish_Mathur: as you can see in the dashboard, I get an error message when I'm trying to produce your measure. Besides that I have also another question. Instead of creating filters per year, is het also possible to drag "Year" to the legend field. If I'm right then I should get 2 lines (one for each year), right?
Many thanks again.
Hi,
That link requires me to sign in.