Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 messages I can't get my measure to work.
I have a fairly easy dataset consisting of 3 tables.
- A download of all incoming mails in 2017
- A download of all incoming mails in 2018
- A table with unique dates, months, month-names and year
I have created a column chart with an easy count function by month and now I wish to make a YTD chart in which the number of emails are adding up per month. In both mail tables there is a date received column, so there should be an easy way to count these, but I don't seem to get it done.
My best effort wa:
YTD 2018 = CALCULATE(COUNTX(Mail2018;DATESYTD(Mail2018[Received])))
Hope you can help me with this.
Thanks a lot.
HI @PowerBiDD,
Please share some sample data to help use clarify your data structure.(please do mask on sensitive data before sharing)
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
I hope you can open the following link. In the line chart is now the number of received emails by month. I would like to make that a YTD chart.
Many thanks in advance.
Regards
HI @PowerBiDD,
I can't view your report from hyperlink. Maybe you can share some sample data/pbix file for testing.
Regards,
Xiaoxin Sheng
Hi Xiaoxin
I don't know how I can add a file to my reply, so I am sharing a photo of the dashboard and one of the raw data.
The lower visuals should be a year-to-date line, but it's obviously not.
I hope this helps you.
Many thanks
Hi,
I would suggest the following:
=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.
HI @PowerBiDD,
You can upload it to onedirve/google drive, then share link here.
BTW, if you store records in different tables, I don't think you can direct use time intelligence functions to get previous from other tables.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
129 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |