Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dax based on Calendar Date

Hello, I'm going to explain my problem. I've got three different tables: 1) Table A : DATE, LABEL, CLIENT_ID, DISTINCTCOUNT(CLIENT_A)     (FILTERED TABLE BASED ON SQL QUERY) 2) Table B : START,...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous ,

First month of year of selected date

CALCULATE(DISTINTCOUNT(TableB[CLIENT_B]) ,DATESMTD(dateadd('Date'[Date],(-1*month(Today())_ +1 ,MONTH)))

 

 

First Month This year Today =
var _min = eomonth(today(),-1*month(Today()))+1
var _max = eomonth(today(),-1*month(Today())+1)
return CALCULATE(DISTINTCOUNT(TableB[CLIENT_B]), FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

 

 

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s