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.
HI,
Im moving my calculated columns into powerquery as I believe thats the 'right' way to do it..
I have some simple calcualtions like a "START" date
Which is the earliest date between 2 dates, I have handled this with a 'normal' MIN function in the desktop.
But how can I express this within a 'add column' in powerquery itself???
Solved! Go to Solution.
Please try-
= if ([Site RTE Actual] < [Site FSI Actual] then [Site RTE Actual] else [Site FSI Actual]
Please mark it as answer if it solves your issue. Kudos are also appreciated.
Not working but I understand your line of thinking and I can tweak it as a conditional column! thanks a lot
Thanks @Shishir22 , whis works... but what if there is no [Site FSI Actual] date... then I will be stuck with a blank, even if the is a [Site RTE Actual]
Please try-
= if ([Site RTE Actual] < [Site FSI Actual] then [Site RTE Actual] else [Site FSI Actual]
Please mark it as answer if it solves your issue. Kudos are also appreciated.
If that is the case then you need to add that condition also-
= if [Site RTE Actual] < [Site FSI Actual] then [Site RTE Actual]
else if [Site FSI Actual] > [Site FSI Actual] then [Site FSI Actual]
else if [Site FSI Actual] = "" then [Site FSI Actual]
else [Site FSI Actual]
Please mark it as answer if it resolves your issue. Kudos are also appreciated.
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |