Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help, Please, with DAX Date Processing

I’m honing my DAX skills in Power BI Desktop, and I’ve run into a snag that I hope the community can help me with.   I’ve been using Reza Rad’s excellent book, Power BI from Rookie to Rock Star: Bo...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous , 

    I'm glad to cooperate you to solve the problem. If the answer is helpful, can you please accept it as a solution? Then we are able to close the thread. And more people who have the same request will benefit here.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ，

For the problem of data loading slowly, you could reference the blog to analyze your report and improve the performance. 

For incorrect results, I can't get you just based on description.  Please share a sample pbix file and your expected results. Then we will understand clearly. 

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, Xue Ding, for trying to help!

     

    I'm not yet to the level of trying to fine-tune performance, but instead I think I'm probably doing something wrong in my DAX formulas.  I'm not sure that posting this response will allow me to upload the PBIX, but I'll try.  The expected results are the sum of total sales dollars for each customer for the selected period (which in my test is the latest 60 days of Order Dates).

     

    Thanks again!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I hoped to get a link for uploading the PBIX when I clicked "Post", but obviously didn't . . .  Could you instruct me how to upload it, please?

       

      Thanks again for your help to this newbie!!

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi Anonymous ,

        Sorry for late back. You can share it via One Drive for business.

         

        Best Regards,

        Xue Ding

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.