Forum Discussion

PowerBiDD's avatar
PowerBiDD
Frequent Visitor
8 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI PowerBiDD,

 

I can't view your report from hyperlink. Maybe you can share some sample data/pbix file for testing.

 

Regards,

Xiaoxin Sheng

PowerBiDD's avatar
PowerBiDD
Frequent Visitor
8 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    I would suggest the following:

     

    1. Append both mail datasets into a single one
    2. Create a relationship from the Date column appearing in the appended dataset to the date column in your Calendar Table
    3. In your visual drag Months from the Calendar Table to the X - axis
    4. Drag the Year (from the Calendar Table) to the slicer and select any one year
    5. Write this measure

    =CALCULATE(COUNTROWS(Data),DATESYTD(Calendar[Date]))

     

    Hope this helps.

    • PowerBiDD's avatar
      PowerBiDD
      Frequent Visitor
      8 years ago

      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.

       

      dashboard received e-mails

       

      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.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        That link requires me to sign in.