Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
i need one help,
here i am showing the first-week date and last week date with respective formulas from below pics and
my question is I need to show the only last 4 completed weeks data from today date in the report
but it is showing the incomplete week data also . i no need that .
Can any one know about this i need last 4 complete weeks data based on first week date and last week date.
below is the pics of my report.
the first week is Sunday
last week is Saturday
Here is the first day of the week formula i used :
Here is the first day of the week formula i used :
Here is the Report i created :
Here is the requirement i need below :
here i want previous 4-week complete data ignore present week bcos it is incomplete.
help me if any one know this.
Thanks
Sandeep kumar
9441181581
avulasandeep19@gmail.com
Solved! Go to Solution.
Here is a detailed example :
Put that filter on your visual or your page and it should do the job
Here is a detailed example :
Put that filter on your visual or your page and it should do the job
hi quentin_vigne,
i took Monday as Week Start Day and Sunday as week End day, but when it was Saturday or Sunday it is showing only last 3 weeks data only, the 4th-week data is Missing.
Can you please tell why it happening??
Date column using the formula : "First week date = (Sales Table[date]+7-weekday(Sales Table[date]),1)"
i am keeping this column in visual level filter and using as the relative date of last 4 calender weeks but it is displaying 3 weeks data when week is "Saturday or Sunday " and by Monday it showing all the 4 Weeks.
Waiting for reply
Thanks
sandeep
A Very Big Thanks (Kudos) to " quentin_vigne "
Its Working fine
Thanks
Sandeep
You can use the relative date filtering as shown below
You can type 4 then weeks to filter your datas
For what you are asking you must use the calendar week options, it will only display the entire weeks
Quentin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |