Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Today minus 1 year

Hi,   Im new to Power BI & DAX and I've the next problem: I have 2 kind of date columns: invoicedate and departure date and 1 sales column: invoicetotal.   Departuredate shows the value of sales...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

For your scenario, you could create the measure with DATEADD function or you could use Filter condition with Today( )-365.

 

If you still need help, please share some sample data and your desired output so that we could help further on it.

 

In addition, you could refer to this video Calculate Transactions In Last N Days in Power BI Using DAX.

 

Best  Regards,

Cherry