Need help with DAX formula datesbetween

PowerBiName — Tue, 25 Aug 2020 12:35:05 GMT

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(table.[due date] >=FirstDayofCurrentYear and table.[due date] <= LastDayofCurrentYear , table[amount] , 0)

What I have done so far : I created a new column named CurrentYearAmount

CurrentYearAmount=if(DATESBETWEEN('table'[due date],[FirstDayofCurrentYear],[LastDayofCurrentYear],'table'[amount],0)) - is it ok?

FirstDayofCurrentYearSold = DATE(YEAR(TODAY()),1,1) is my measure that calculates my start date from current year

LastDayofCurrentYearSold = ??? how do I make that

I'm stuck at this point and I don't know what to do next.

Maybe I didn't take the right approach to do this so other ideas are welcome also.

Thanks in advance, and sorry for my bad english 😞

Best regards,

Bogdan

Re: Need help with DAX formula datesbetween

amitchandak — Tue, 25 Aug 2020 12:47:10 GMT

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))