Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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))
@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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |