Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@jaleef
I have attached the files below my signature for you to go through and understand.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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())),
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@jaleef
I have attached the files below my signature for you to go through and understand.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |