Forum Discussion
Help with Date filtering on measure
I have a table that has contract data and I need to show Contract YTD info. Here is an example: Contract1 active dates 1/1/2018 - 12/31/2018 Contract2 active dates 4/1/2018 - 5/31/2019 Contrac...
It was not solved in Power BI. I had to change my fact table to include the Sales Quantity to get it to work as desired. Not ideal.
Try this.
TOTALYTD(SUM(factSales[Quantity]),'Calendar'[Date],ALL(factSales),"5/31/2019") - for Contract 2.
Use the same for Contract 1 and 3 (change the year end date), it will work.
Please let me know if you have any questions.
Regards,
Pavan Vanguri.