Forum Discussion

PowerBiName's avatar
PowerBiName
New Member
6 years ago
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(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
 

 

 

  • amitchandak's avatar
    amitchandak
    6 years ago

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

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