Forum Discussion
Solved
Week Filter
Hi Guys - Could you please help me create a week filter that could describe the days of the selected week? Can that be done in Power BI? I have date filters; Year, Months, & WeekOfYear, and my l...
Hi, jiji ;
You could create a measure then add it into card.
Measure = CALCULATE(MIN('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month])) & "-"&CALCULATE(MAX('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month]))The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, jiji ;
You could create a measure then add it into card.
Measure = CALCULATE(MIN('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month])) &
"-"&CALCULATE(MAX('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month]))The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.