Forum Discussion
Solved
Need help with DAX formula datesbetween
Hi, I'm new to powerbi dax and any help is appreciated. What I'm trying to achive and I don't succeed is to create a new column or a measure in a table where the below condition takes place : if(t...
PowerBiName , what are trying to achieve here
you can join due date with date table and you can have a year there and filter
ot have formula like
measure =
var _min = date(year(today()),1,1)
var _max = date(year(today()),12,31)return
calculate(countrows(Table) , filter(Table, table[date]>=_min && table[date] <=_max))
amitchandak
Super User
Super UserPowerBiName , what are trying to achieve here
you can join due date with date table and you can have a year there and filter
ot have formula like
measure =
var _min = date(year(today()),1,1)
var _max = date(year(today()),12,31)
return
calculate(countrows(Table) , filter(Table, table[date]>=_min && table[date] <=_max))