Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Display date will be todays date

How to display todays date in report , next day open report means next day display
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Anonymous,

 

Do you want to show the data last 2 weeks or calculate the data last 2 weeks?

 

If you want to calculate the data last 2 weeks, you could use Today()-14.

 

Measure = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Date]=TODAY()-14))

If you want to show the data last 2 weeks, you could try with relative date slicer. When you open your report next day, it will show the data from 7/18/2018-7/31/2018.

 

 

If you still need help, please share some your data sample which could reproduce your scenario and your expected output.

 

Best  Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi 

Thanks to reply

 

Requirement is , last 2 weeks an employee worked given tasks . So we need to find the completed tasks from last 2 weeks 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    If we check every day like tomorrow once and day after tomorrow once , date should change from current date to previous 14 days(2weeks)

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi Anonymous,

     

    Please have a reference of this similar thread.

     

    Best Regards,

    Cherry