Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I'm trying to set up the following if function:
Surveyed in 2017? = IF(AND([Survey timing].[Date]>9/30/2016,(wave_client_details[Wave status]="1. Surveyed")),"Yes","No")
However, it looks like the greater than date portion isn't working since I'm seeing "1. Surveyed" results for rows where the date is 2014 or 2015.
Any ideas on how I can get the date portion to work correctly?
Thanks so much!
Dakota
Solved! Go to Solution.
Try using the date function:
Surveyed in 2017? = IF(AND([Survey timing].[Date]>9/30/2016,(wave_client_details[Wave status]="1. Surveyed")),"Yes","No")
Personally, I would use && instead of the and function. It's easier to read and can add multiple ANDs.
Surveyed in 2017? =
IF (
[Survey timing] > DATE ( 2016, 9, 30 )
&& wave_client_details[Wave status] = "1. Surveyed" ,
"Yes",
"No"
)
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
=Table.AddColumn(#"Removed Columns", "90day>=", each if [LastDateIn] >= (DateTime.FixedLocalNow()-90) then "true" else "false")
in excel it works
=If (c1<=TODAY()-90,"Yes","No")
Hi,
Write this calculated column formula
=if(Data[LastDateIn]<=today()-90,"Yes","No")
Is that trying to convert the Column to DateTime? The excel function I used worked. But in power Query does not.
My solution will work in the Data Model (not in the Query Editor). Mine is a calculated column formula (to be used in DAX) not an M language formula.
Can I use that for automation? I'm just trying to automate excel so I don't have to keep doing the same thing over again.
Yes, you can.
So Data model can automate tasks in excel! Sweet thanks
I have a similar problem. I have a table which I would like to show a sum of Today and Greater Than total sum.
ex: Todays100 Pull Rate 85% = CALCULATE(SUM(PullRateTable[100M Needed]) *.85)
FILTER('DateTable',
'DateTable'[Date] = TODAY()&>
Hi,
Try this
=CALCULATE(SUM(PullRateTable[100M Needed])*.85,FILTER('DateTable','DateTable'[Date] >= TODAY()))
Hope this helps.
Thanks Ashish! I'll see if I get the correct total for tomorrow.
Lisa
Try using the date function:
Surveyed in 2017? = IF(AND([Survey timing].[Date]>9/30/2016,(wave_client_details[Wave status]="1. Surveyed")),"Yes","No")
Personally, I would use && instead of the and function. It's easier to read and can add multiple ANDs.
Surveyed in 2017? =
IF (
[Survey timing] > DATE ( 2016, 9, 30 )
&& wave_client_details[Wave status] = "1. Surveyed" ,
"Yes",
"No"
)
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Worked like a charm - thanks so much!
(And definitely moving forward with using &&)
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |