Question : Nested If M Language
Answered by : nilotpal-choudhury
if [Requested Date] >= #date(2018, 1, 1) and [Requested Date] <= #date(2018, 1, 26)
then #date(2018, 1, 1)
else if [Requested Date] >= #date(2018, 1, 27) and [Requested Date] <= #date(2018, 2, 23)
then #date(2018, 2, 1)
else #date(9999, 12, 31)Source : https://community.powerbi.com/t5/Desktop/Power-Query-Nested-IF-AND-Statement/m-p/540348#M253724 | Last Update : Thu, 20 Jan 22