I put a slicer in there to help me figure things out it’s not needed in fact it’s part of the problem. I’m using to select a date and getting previous date value.
Test D = CALCULATE
(
ClasseRequisitionLait[Sum Volume] example: 10 744 944
)
+ CALCULATE(VolumeLendemainParClasse[Volume Lademain par Classe]) example: 1 964 000
PREVIOUSDAY(VolumeLendemainParClasse[DateLivraisonPrevue]
is a slicer, when the slicer is on the date my calc
work for that day only, all the others are wrong.
If I change the date on the slicer then that calc is correct but the other
calc including the one that worked before is no longer correct.
How can I have all my calcs working … ?
I know, it’s my slicer with the PREVIOUSDAY that is causing me problems
and I don’t need the slicer. The slicer is just pointing to a date which I need
the previous date value for my calculation.
and I’m sure my calculate could be greatly improved.
Thank you Greg, I will see what I can do to clean up my file to the minimum where I have my problem and just the data which is not that much needed anyway to get see my problem.
Let me work on that.
As added info, I really think the calculate is the problem where I get my current date and my prior date value. Which is correct until I switch my date then the new selecting is ok but the one was correct before no longer is.
I’ll work in that and come back with my file. But maybe you would have a suggestion for my calculate ?
Hi @erict. Unfortunately no … it is one of the central purposes of this forum to share both issues and solutions, so having a record that may help others in future searches for similar issues is paramount. Please modify your PBIX or create a separate small sample PBIX such that it can be posted (and thus shared publicly) where many forum members may benefit from the analysis of the issue (perhaps using the techniques described in the above-referenced video from @BrianJ on sanitizing data).
Greg
Hi @ericet, did the response provided by @Greg help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!
Turns out it was just a big mess, so I redesigned what I was doing and got to move forward with my project. Found a different way to move things along.
The thing that drive me a little crazy is when I see Sam do his Power BI it always looks easy, yet when I do it it’s far from being easy …
But, I have other issues … but one problem at the time.
Thanks all, I will continue my Power BI programming and continue watching the Enterprise DNA teaching videos. I bought a 1 year membership in January .
Expertise is a skill that that only hard work and experience makes you gain and the path to this expertise is not always easy …
NO! It is absolutely not just you having issues like this - we ALL still have issues exactly like this. I always laugh when somebody sheepishly posts on the forum that “they are still learning Power BI”. Even as an “Expert”, I literally still learn new things about this program every single day, much of it here on this forum. (The main thing that I think distinguishes the expert from the nonexpert is that the former has a much better grasp on how much they still don’t know…).
The videos are an excellent resource and I encourage you to watch as many of them as possible since they provide an excellent foundation on which to build upon. But the only thing that will truly make a big difference in your skill level is practice, practice and practice over an extended time period.
Your membership provides some awesome opportunities to structure that practice and get the most out of your practice time. Two that I would specifically highlight are the Enterprise DNA Data Challenges and the eDNA Problem of the Week. Information about each can be found in the videos at the top of the forum page, and people at all skill levels are encouraged to participate in both.
In addition, I put together the following video that you may find helpful, which provides a range of specific strategies to strengthen your Power BI skillset over time.
Hello @ericet I hope that you are having a great experience using the Support Forum so far. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
Hi @ericet, did the response provided by @BrianJ you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!
Hi Brian
I was looking to download the resources in your comment for practicing dax and M code. I try it but i can’t download. [ DAX and M Functions of the Day v1.1.pbix].
Thanks
Hi @ericet, we’ve noticed that no response has been received from you since the 23rd of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Happy to address this one and provide the resources, but can you please request that in a new topic so that it doesn’t get buried within an unrelated thread? This will make it easier for others to find it as well.
Hi @abbi, just a friendly reminder, If you have a follow up question or concern related to a different topic than on this thread, please start a new topic. More details can be found here - Asking Questions On The Enterprise DNA Support Forum.
Hi @ericet, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
