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 DAX Gurus,
I have a requirment to instert a tag for a last three month period into a continues date tabel. It works fine for last two months but it seems to have issue when I try to get the thrid month. below is my formula. I can see both 1 and 2 in the date tabel but I cannot see 3 in my date table column.
CurrentMonth1 =
Solved! Go to Solution.
Sorry, @amaleranda
its my bad. try this
CurrentMonth1 =
var _dDiff = DATEDIFF([Date], TODAY(), MONTH)
RETURN
IF(_dDiff > 0 && _dDiff < 4, _dDiff, 100)
Try like
CurrentMonth1 =
SWITCH(
TRUE(),
format([Date],"YYYYMM") = format(Date(YEAR(TODAY()) , MONTH([Date])-1,1),"YYYYMM") ,1,
format([Date],"YYYYMM") = format(Date(YEAR(TODAY()) , MONTH([Date])-2,1),"YYYYMM") ,2,
format([Date],"YYYYMM") = format(Date(YEAR(TODAY()) , MONTH([Date])-3,1),"YYYYMM") ,3,
100
)
@amaleranda , can you share the error
try my suggestion above
Hi @amaleranda
the issue in the Year. now is 3rd month and there is no date with month number 0
I think you ned to use DATEDIFF function:
CurrentMonth1 =
var _dDiff = DATEDIFF([Date], TODAY(), MONTH())
RETURN
IF(_dDiff > 0 && _dDiff < 4, _dDiff, 100)
hi @az38 ,
excalty, that is the issue, but I just copied your code into the calander, it didnt seem to work.
I am pretty sure there is more to this code as you understand the issue. can you kindly put whole code in here for me.
Thanks.
I think its exactly what you need.
Please, show example of data in your calendar table
Do you create a column or measure? this statement for column
@az38 ,
When I am in current month I need to see last three months from month before.
ie. In March I should see feb 2020 as 1, jan 2020 as 2 and dec2019 as 3
if the curent month is Aug 2020
then I should see jul2020 as 1, june202 as 2 and may2020 as 3
Now (in March) it works ok? If so, it will also work in appropriatedway in August
Sorry, @amaleranda
its my bad. try this
CurrentMonth1 =
var _dDiff = DATEDIFF([Date], TODAY(), MONTH)
RETURN
IF(_dDiff > 0 && _dDiff < 4, _dDiff, 100)
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |