topic Re: previous date in DAX Commands and Tips

previous date

faheem_Latif_BI — Tue, 08 Nov 2022 06:58:20 GMT

Hi ,

Im using this for current month and year which is working fine.

currentdate=(Date.ToText(DateTime.Date(DateTime.LocalNow()),"MMyyyy"))

Output is =112022

now i want to get prevoius month

Pdate=(Date.ToText(DateTime.Date(DateTime.LocalNow()),"MMyyyy")) -1

but its not working please advise.

Re: previous date

Samarth_18 — Tue, 08 Nov 2022 07:32:23 GMT

Hi faheem_Latif_BI ,

Please try below mquery code in custom column:-

Text.PadStart(Text.From(Date.Month(DateTime.LocalNow())-1),2,"0")&Text.From(Date.Year(DateTime.LocalNow()))

Re: previous date

faheem_Latif_BI — Tue, 08 Nov 2022 07:38:13 GMT

Thanks for reply im using like this but giving me error

Table.AddColumn(#"Added Custom", "Previous_MonthYear", each Date.ToText(Text.PadStart(Text.From(Date.Month(DateTime.LocalNow())-1),2,"0")&Text.From(Date.Year(DateTime.LocalNow())),"MMyyyy"))

Re: previous date

Samarth_18 — Tue, 08 Nov 2022 07:42:19 GMT

Could you please share the error?

Re: previous date

faheem_Latif_BI — Tue, 08 Nov 2022 07:44:41 GMT

Re: previous date

wdx223_Daniel — Tue, 08 Nov 2022 07:52:31 GMT

Pdate=Date.ToText(Date.AddMonths(DateTime.Date(DateTime.LocalNow()),-1),"MMyyyy"))

Re: previous date

Samarth_18 — Tue, 08 Nov 2022 08:15:58 GMT

faheem_Latif_BI Please try this:-

#"Added Custom" = Table.AddColumn(#"Added Custom", "Previous_MonthYear", each Text.PadStart( Text.From(Date.Month(DateTime.LocalNow())-1),2,"0")&Text.From(Date.Year(DateTime.LocalNow()))) in #"Added Custom"

Re: previous date

faheem_Latif_BI — Tue, 08 Nov 2022 08:46:50 GMT

smart 18

UR star