Forum Discussion

Malinpetersson's avatar
Malinpetersson
Regular Visitor
6 years ago

Yesterday or day before

Hi!   I need a mesure that brings the value back if ther is a value yesterday and if not it will bring the value from the day before yesterday, or before that day, last year. The value I am looking...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Malinpetersson ,

 

Sorry I cannot get you, could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Malinpetersson's avatar
Malinpetersson
Regular Visitor
6 years ago

Hi,

 

how do I add the information?

 

 I have an list in excel whit data from mars 2019 and some date from mars 2020. We do the invocing every monday-friday and when I look to the rapport at monday I want the rapport to show fridays amount. When I look at the rapport at thusesday I want it to show mondays invoicing.

 

thanks 
Malin