https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014063#M1027556 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="494643" data-lia-user-login="Vishal_2202" class="lia-mention lia-mention-user">Vishal_2202</a> , yes the code is for custom columns only</P> Wed, 11 Jan 2023 14:26:08 GMT amitchandak 2023-01-11T14:26:08Z https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3013826#M1027483 <P>I want previous sys date&nbsp;</P><P>&nbsp;</P><P>So how to create custom column for that</P> Wed, 11 Jan 2023 13:12:00 GMT https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3013826#M1027483 Vishal_2202 2023-01-11T13:12:00Z https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014049#M1027551 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="494643" data-lia-user-login="Vishal_2202" class="lia-mention lia-mention-user">Vishal_2202</a> , DAX</P> <P>&nbsp;</P> <P>Date = today() -1</P> <P>&nbsp;</P> <P>Power Query</P> <P>=Date.AddDays(DateTime.Date(DateTime.LocalNow()),1)</P> <P>&nbsp;</P> <P>Check</P> <P><A href="https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X" target="_blank">https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X</A></P> <P>&nbsp;</P> Wed, 11 Jan 2023 14:24:49 GMT https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014049#M1027551 amitchandak 2023-01-11T14:24:49Z https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014058#M1027553 <P>I want that in custom column so I can make another custom column with it.</P><P>&nbsp;</P> Wed, 11 Jan 2023 14:24:32 GMT https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014058#M1027553 Vishal_2202 2023-01-11T14:24:32Z https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014063#M1027556 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="494643" data-lia-user-login="Vishal_2202" class="lia-mention lia-mention-user">Vishal_2202</a> , yes the code is for custom columns only</P> Wed, 11 Jan 2023 14:26:08 GMT https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014063#M1027556 amitchandak 2023-01-11T14:26:08Z https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014120#M1027573 <P>Power Query formula works just a small correction there should -1 instead of 1.</P><P>&nbsp;</P><P>Thanks for help</P> Wed, 11 Jan 2023 14:43:55 GMT https://community.fabric.microsoft.com/t5/Desktop/Previous-date/m-p/3014120#M1027573 Vishal_2202 2023-01-11T14:43:55Z