Forum Discussion

Rohini's avatar
Rohini
Icon for Helper I rankHelper I
6 years ago
Solved

Power Query Editor - Current Month Issue

Reporting values during a current month requires pulling data pertaining to previous month i.e., during March, I need to extract data from the field [Feb 2020], in April, I need to extract data from ...
  • az38's avatar
    az38
    6 years ago

    Hi Rohini 

    for Power Query use Date.Month(DateTime.LocalNow()) function

    like

    = if Date.Month(DateTime.LocalNow())=3 
then [Feb 2020]
else if Date.Month(DateTime.LocalNow())=4
then [Mar 2020]
else "999999999"
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Rohini 

for Power Query use Date.Month(DateTime.LocalNow()) function

like

= if Date.Month(DateTime.LocalNow())=3 
then [Feb 2020]
else if Date.Month(DateTime.LocalNow())=4
then [Mar 2020]
else "999999999"