Forum Discussion
Helper IDates - Last 4 weeks, Next 4 weeks
Dates !!!! :)
In Dynamics CRM its very easy to pull off a report of for example all Orders older than X week, or Orders due in Next X weeks. Seems odd that Power BI doesnt have this simple function, dont you think?
There is a Microsoft provided content pack for Dynamics CRM sales, a pre-built dashboard and set of reports. I notice they have done exactly what i need to do, see screenshot. I need to create one called "Last4Weeks" and also need the ability to select truor or false, just like Microsoft have done here. How have they done this???
You can edit it after this step manually, just add seciond condition in code
4 Replies
hohlickContinued Contributor
Hello P0W3RB1
You can add custom column with UI in Query Editor:
- Select dates column
- In "Add column" tab in "Date" group select Age
- Select new column, in "Transformation" tab in "Duration" group select "Days"
- Add custom conditions column with condition like "if [AgeFromDate]<28 and [AgeFromDate]>0 then true else false", name it Last4Weeks
- Add custom conditions column with condition like "if [AgeFromDate]>-28 and [AgeFromDate]>0 then true else false", name it Next4Weeks
- You can finetune where to add todays orders
- hohlick
You can edit it after this step manually, just add seciond condition in code
