Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 &&)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
107 | |
106 | |
81 | |
37 | |
35 |
User | Count |
---|---|
168 | |
107 | |
70 | |
66 | |
58 |