Getting date value of current chosen month till previous months

[Anonymous]

Hello Everyone!!

I am stuck at a dax problem.
I have two tables i.e Date table and File closure table( this table is having file closure month that is having a relationship with date table month). now i am using month name from date table into my slicer and want to count the number of row in file closure table from chosen month till the start of the year.

E.g. say i chosed march from slicer than the number of rows i want to count from file cosure table should be from january till march.

I cannot chose multiple months to add previous  month data due to my schema limitations.

Kindly help me out in resolving this issue. 

[amitchandak]

@Anonymous , In this case DatesYTD or TotalYTD should help. Make sure the Date table is marked as a date table

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a

[wdx223_Daniel]

CALCULATE(COUNTROWS(FileTable),DATESYTD(Dates[Date]))