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,

 

Please share some sample data to help use clarify your data structure.(please do mask on sensitive data before sharing)

 

Regards,

Xiaoxin Sheng

PowerBiDD's avatar
PowerBiDD
Frequent Visitor
8 years ago

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.

 

 link to pbix file

 

Many thanks in advance.

 

Regards

  • 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