topic Getting date value of current chosen month till previous months in DAX Commands and Tips

Getting date value of current chosen month till previous months

Anonymous — Fri, 06 Nov 2020 07:29:53 GMT

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.

Re: Getting date value of current chosen month till previous months

wdx223_Daniel — Fri, 06 Nov 2020 07:36:57 GMT

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

Re: Getting date value of current chosen month till previous months

amitchandak — Fri, 06 Nov 2020 07:50:46 GMT

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