Dynamic display selected date and last week date in the header

H_insight — Thu, 16 May 2024 11:01:29 GMT

Hiya,

I’m currently working on a Power BI report and facing a challenge with creating a dynamic header that updates based on slicer selections (Day of Week). Specifically, I want the header to dynamically display the selected date and the date one week prior.

The goal is to have the below output, based on selecting Monday as day of week and current month of May 2024 (06/05/2024).

Here is a link to the sample file.

Thank you

Re: Dynamic display selected date and last week date in the header

lbendlin — Fri, 17 May 2024 00:42:35 GMT

In such scenarios your slicer needs to be fed from disconnected tables,

topic Dynamic display selected date and last week date in the header in DAX Commands and Tips

Dynamic display selected date and last week date in the header

Re: Dynamic display selected date and last week date in the header