User Profile

JMelo

Frequent Visitor

Joined 7 years ago

7 Posts

View All Badges

User Widgets

Contributions

Re: BUG: We couldn't get your datamart's updated schema
Same error here. Houston, TX. Activity ID: b39737a8-a268-4f7a-b206-5d33d10a2e41 Request ID: 8515b1ad-6bac-4347-ad85-272f475f3db0 Correlation ID: 3e4221d6-a625-7f06-3ce5-032ebfc4912d Status code: 400 Time: Wed May 31 2023 15:35:02 GMT-0500 (Central Daylight Time) Service version: 13.0.20772.76 Client version: 2305.4.14049-train Cluster URI: https://wabi-south-central-us-redirect.analysis.windows.net/
3 years ago Place Issues
5KViews
0likes
0Comments
Re: M Query: Add list of months between dates
This was great, thank you for sharing this!! It also solved my problem. But I have this challenge to create one row for each individual day (as opposed one for for month). I'm trying to tweak the code, but it's givning me errors. Could you please assist? Much appreciated!
4 years ago Place Desktop
17KViews
0likes
1Comment
Re: Scatterplot over time
Month Product Price Jan-19 Shirt 167 Jan-19 Jeans 229 Jan-19 Shorts 201 Feb-19 Shirt 105 Feb-19 Jeans 205 Feb-19 Shorts 196 Mar-19 Shirt 213 Mar-19 Jeans 209 Mar-19 Shorts 163 Apr-19 Shirt 236 Apr-19 Jeans 55 Apr-19 Shorts 200 May-19 Shirt 205 May-19 Jeans 120 May-19 Shorts 121 Jun-19 Shirt 250 Jun-19 Jeans 246 Jun-19 Shorts 72 Thanks, this is the dataset, would it help?
6 years ago Place Desktop
2KViews
0likes
1Comment
Scatterplot over time
Hi, on this example i have 3 producs with different prices each. Could anyone give me a hint? Lets say: Jan Product 1 - $100 Produc 2 - $200 Produc 3 - $300 Feb Product 1 - $50 Produc 2 - $55 Produc 3 - $60 I need to plot a scatterplot time over month, without summarize Producs. I want to see Product 1, 2, and 3 distribuited in that month Example:
Solved
6 years ago Place Desktop
Need Help
2KViews
0likes
3Comments
Re: Power Query: Count Months within Date Interval, by Year
Any help please?
7 years ago Place Desktop
2.3KViews
0likes
1Comment
Re: Power Query: Count Months within Date Interval, by Year
The desired solution would to add one column for each year within the date interval. Power Query Table as is in the Database: Contract Name Start Date End Date Test 123 04/01/2016 12/01/2018 Power Query Table after data modeling: Contract Name Start Date End Date Months in 2016 Months in 2017 Months in 2018 Test 123 04/01/2016 12/01/2018 9 12 12
7 years ago Place Desktop
2.3KViews
0likes
2Comments
Power Query: Count Months within Date Interval, by Year
Good evening eveyone! I have a challenge where i need to count the amount of months each row For each row i have a start date and end date. Start Date: 04/01/2016 End Date: 12/01/2018 Answer: Add a Column "Year 2016" with 9 months Add a Column "Year 2017" with 12 months Add a Column "Year 2018" with 12 months Please note Start Date and End Date may vary to any year (before 2016 or after 2018). Could you please help me? Thank you! JMelo
Solved
7 years ago Place Desktop
Need Help
2.3KViews
0likes
4Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.