Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jaleef
Regular Visitor

loading only last 3 month data from table

Hi ,

 

i need data from last 3 month from a table , and it should not filter it from the current day for last three month it should consider only the month , for examble if its 23 rd of may month i need to get data from march 1 ,   i have filtered my table date column as in t his current quarter it didnt help , 

 

#"Filtered Rows" = Table.SelectRows(incidents_table, each Date.IsInCurrentQuarter([createdon])),

 

any help 

1 ACCEPTED SOLUTION

@jaleef 

I have attached the files below my signature for you to go through and understand. 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

5 REPLIES 5
Fowmy
Super User
Super User

@jaleef 

Try the following code

#"Filtered Rows" =
Table.SelectRows(incidents_table, each [createdon] >=  Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-2)) and [createdon] <= Date.From(DateTime.LocalNow())),



 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hi @Fowmy 

i am getting below error 

 

jaleef_0-1621755824717.pngjaleef_1-1621756041313.png

 

@jaleef 

If you do not need the time pat of the date column, you can remove the time as I showed below. Do it before filtering the dates

Fowmy_0-1621756391765.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hi @Fowmy 

 i didt but still its showing same error

jaleef_0-1621760287686.png

 

@jaleef 

I have attached the files below my signature for you to go through and understand. 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.