Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
1 year ago
Solved

If dates logic power query

Hi, 

I have a calculated column that takes a date range and groups it into its own financial period. 

 

Switch(

True(), 

Test[date] >= date(2017,10,1) && test[date] <= date(2018, 04, 6), "17/18",

Test[date] >= date(2018,10,1) && test[date] <= date(2019, 04, 6), "18/19", blank()

)

 

Does anyone know how to recreate this logic in Power Query please using the Add Column? 

 

Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    1 year ago

    Hy M_SBS_6 

     

    Yes, You can do it by using this code.

     

    if [Date] >= #date(2017, 10, 1) and [Date] <= #date(2018, 4, 6) then "17/18"
else if [Date] >= #date(2018, 10, 1) and [Date] <= #date(2019, 4, 6) then "18/19"
else null

     

     

    Best Regards,
    Muhammad Yousaf

     

    If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

     

    LinkedIn

1 Reply

  • muhammad_786_1's avatar
    muhammad_786_1
    Solution Supplier
    1 year ago

    Hy M_SBS_6 

     

    Yes, You can do it by using this code.

     

    if [Date] >= #date(2017, 10, 1) and [Date] <= #date(2018, 4, 6) then "17/18"
else if [Date] >= #date(2018, 10, 1) and [Date] <= #date(2019, 4, 6) then "18/19"
else null

     

     

    Best Regards,
    Muhammad Yousaf

     

    If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

     

    LinkedIn