The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
To convert the following tableau calculated field to Power BI Dax, which I faced issue while doing this.
STR(if year(TODAY()) = year([Calender]) and month(TODAY())= MONTH(Calender]]) then 1
elseif year(TODAY()) = year(Calender]) and
(month(TODAY())- MONTH(Calender])) >=0 then 1
elseif year(TODAY())-1 = year(Calender]) and
(month(TODAY())- MONTH(Calender])) < 0 then 1
else 0 end)
Help with this is really appreciated.
Thanks in advance
Solved! Go to Solution.
@asdf1608 ,Assuming calendar is name of date column, a new column like
Switch( True() ,
year(TODAY()) = year([Calender]) && month(TODAY())= MONTH(Calender]]), 1
year(TODAY()) = year(Calender]) && (month(TODAY())- MONTH(Calender])) >=0 ,1
year(TODAY())-1 = year(Calender]) && (month(TODAY())- MONTH(Calender])),1,0)
@asdf1608 ,Assuming calendar is name of date column, a new column like
Switch( True() ,
year(TODAY()) = year([Calender]) && month(TODAY())= MONTH(Calender]]), 1
year(TODAY()) = year(Calender]) && (month(TODAY())- MONTH(Calender])) >=0 ,1
year(TODAY())-1 = year(Calender]) && (month(TODAY())- MONTH(Calender])),1,0)
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |