I need help to create a measure by referring to the below table.
Measure:- If the created_at is less than or equal to 90 days (of Calendar Date) it is "TRUE" else "FALSE".
Go to Solution.
Dear @gauravnarchal .This measure will do the work
View solution in original post
Hi @gauravnarchal ,
According to my understanding, you want to create a True/False flag when the date is within/not within 90 days(Comparing with the last day in the Created_at column), right?
You could use the following formula:
SELECTEDVALUE ( 'diff'[Created_at] ),
CALCULATE ( MAX ( 'diff'[Created_at] ), ALL ( diff ) ),
) <= 90,
My visualization looks like this:
Is the result what you want? If not, please upload some data samples and expected output.
Please do mask sensitive data before uploading.
@gauravnarchal ,Please let me know that did you got your answer which i mentioned earlist of all .which was
I would use the below measure.
_90_OrLess = IF(TODAY()-Table[Picking Date]<=90,True,False) //It will result in a boolean data type, if you need as text use IF(TODAY()-Table[Picking Date]<=90,"True","False")
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
Hey @gauravnarchal ,
what exactly do you mean by "Calendar Date", do mean toda? Do you want to create a calculated column or a measure?
Do you have a dedicated Calendar table, how does this table relate to the table in your picture?
Nevertheless, based on my sample data
This DAX statement
var _today = TODAY()
var dateofthecurrentrow = [Date]
var _datediff = DATEDIFF(dateofthecurrentrow , _today , DAY)
IF(_datediff < 90 , "True" , "False")
Creates this calculated column:
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.