sureshsonti
Member
These are the fields in my Data Set. I am trying to avoid filters on the report. I have attached a small sample data set
Order Date
Year
Month
Units Sold
1. I want to extract Units Sold as of today (Current Day) based on the Order Date
2. I want to extract Units Sold as of same day (Last Year) based on the Order Date
Want to compare Units Sold Today and Last Year same Day using DAX formula. Trying to avoid filters on the report
Example 12/17/2018 and 12/17/2017
Thanks for your help
Order Date
Year
Month
Units Sold
1. I want to extract Units Sold as of today (Current Day) based on the Order Date
2. I want to extract Units Sold as of same day (Last Year) based on the Order Date
Want to compare Units Sold Today and Last Year same Day using DAX formula. Trying to avoid filters on the report
Example 12/17/2018 and 12/17/2017
Thanks for your help