Hello,@Ritaf1983 Thank you for your interest in this case. I have supplemented the data according to the user's request and realized the results. Please check if there is anything that can be improved. Below is my solution:
Regarding the issue you raised, my solution is as follows:
1.First I have created the following table and the column names and data are the data you have given:
2.I created the following measure to count whether or not there was a Monday in that week, and the resulting graph is below:
Monday = IF(WEEKDAY(MINX(FILTER(ALLSELECTED('Table'),'Table'[Week]=MAX('Table'[Week])),'Table'[Date]))=2 ,"YES","NO")
3.I created the following measure to enable filtering for values that don't have a Monday:
Measure2 =
if ('Table'[Monday]="No",1,0)
4.Regarding your desire to do a weekly day-by-day accumulation of the values for weeks with a Monday, I created the following measure:
Measure 1 = CALCULATE(SUM('Table'[Vlaue]),FILTER(ALLSELECTED('Table'),'Table'[Date]<=MAX('Table'[Date])&&'Table'[Week]=MAX('Table'[Week])&&'Table'[Monday]="YES"))
5.Here's my final result, which I hope meets your requirements.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1.First of all, please click "Transform data" to enter the powerquery page to check whether the format of the date column you selected is Date.
2.After successful modification, I hope you can check whether the modified format is the same as what you want. Below is the screenshot of the common error report:
Powerbi generally recognizes date columns in the process, it is difficult to recognize the dd/mm/yyyyy type, so it is recommended that you change the date data to mm/dd/yyyyy or other types.
3.Here's my final result, which I hope meets your requirements.
If what you have done still does not solve the problem, you can choose to share the sensitive data deleted pbix with me, I will help you to modify. Be sure to delete sensitive information.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1.Below is my reproduction of your scenario, but without the problems you are experiencing:
To reproduce the problem you are having, I have also created the calculation table as shown below:
Table = CALENDAR(TODAY()-20,TODAY())And using the following calculated column, I output the day of the week for that date:
Week = WEEKNUM('Table'[Date],21)Secondly, to make it easier for you to see what day of the week the date is, I have also created the following calculated column:
tod1 = FORMAT('Table'[Date],"dddd" )Lastly I also used the following measure to determine if there is a Monday in the week:
Monday = IF(WEEKDAY(MINX(FILTER(ALLSELECTED('Table'),'Table'[Week]=MAX('Table'[Week])),'Table'[Date]))=2 ,"YES","NO")Below is a graph of my final output:
2. You can try using DAX queries on desktop to check and test your metrics or calculated columns sentence by sentence, here are the relevant links:
DAX query view in Power BI Desktop - Power BI | Microsoft Learn
My pbix file is also added as an attachment to the reply so you can check it. If there is still a problem, you can choose to send me the pbix file after removing the sensitive information (please be careful to remove the sensitive information) or please check if your desktop needs to be updated and update it promptly.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could it be something in the configuration of the program itself or versions? When I open your sample file, I get this error:
But it opens it up. Copying as it is to a clean GDP continues to give me the same error (it won't let me attach it).
Here's my version:
Thanks for letting us know your user experience. According to your case description, I do understand how frustrated you are now.
Regarding the issue you raised, my solution is as follows:
1.According to the screenshot and description of your error report, your statement is correct, your requirement may indeed not be realized in your current version.You can try upgrading the version number, here is a screenshot of mine:
If you want to get the instant help, it is recommended that you can upgrade the product to the latest version.
2.This is the official download link:
Download Microsoft Power BI Desktop from Official Microsoft Download Center
If you need other help from my side, please let me know.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
