Display auto weekly date on card in power BI

[anis_keyna]

Hi All,

I'm having difficulty in display week automatically in power BI. The idea is the date for weekly will be get from data sources. For data example 11/05/2018 to 17/05/2018, 18/05/2018 to 24/05/2018. Before this I have to type and change manually when the date is coming. Is there possibility to make it automate by using formula. I'm new to power bi and just getting started to explore. 

[v-qiuyu-msft]

Hi @anis_keyna,

The Card visual can display only one value instead of multiple values. 

In your scenario, would you please clarify "The idea is the date for weekly will be get from data sources. For data example 11/05/2018 to 17/05/2018, 18/05/2018 to 24/05/2018. "? Do you mean you want to display value "11/05/2018 to 17/05/2018" in the card visual? 

Best Regards,
Qiuyun Yu  

[anis_keyna]

Yes I would like to display 11/05/2018 to 17/05/2018" in the card visual. The idea is to auto display when it reach the date. Meaning the date display will be change weekly based on the data sources. Is it possible?  

[v-qiuyu-msft]

Hi @anis_keyna,

Not sure the exact date you mean in this sentence "The idea is to auto display when it reach the date. " Assume it's the maximum date in the table, you can create a calculated column to return the maximum date below:

MaxDate= CALCULATE(MAX('Table'[Date]),ALL('Table'))

Then you can create a measure: 

Measure = DATEADD('Table'[MaxDate],-7,DAY) & "to " & MAX('Table'[MaxDate])

If above doesn't meet your requirement, please use some sample data to show desired results. 

Best Regards,
Qiuyun Yu