User Profile

raisurrahman

Helper II

Joined 10 months ago

29 Posts11 LikesLikes received2 Solutions

View All Badges

User Widgets

Contributions

Re: Partial text Matches in Nested Lists
KDTF1023 It would be helpful if you could share a sample dataset along with the expected output format.
7 months ago Place Power Query
1.3KViews
0likes
0Comments
Re: New to Power Query – where should I start?
Welcome to the world of Power Query. Here is a 3-step approach I recommend for new learners: 1. Learn the GUI: Focus on button-based solutions first. 2. Learn the Patterns: Master the common data scenarios you will face daily. 3. Learn the Code: Dive into M code only after you are comfortable with the basics. If you like learning from books, I highly suggest starting with "Master Your Data with Excel and Power BI" by Ken Puls and Miguel Escobar. To understand data patterns, "Power Query Recipes" by Ken Puls is the perfect path. After you have mastered those, you can pick up "Power Query: Beyond the User Interface" by Chandeep Chhabra. Best of luck!
7 months ago Place Power Query
1.5KViews
1like
0Comments
Re: Passing Start and End dates from a calendar-style date slicer to Power Query parameters (Bigquery)
Madhu155 No — it is currently NOT possible to bind a calendar-style date slicer (including Between or calendar pickers) to Power Query parameters in a supported way. But third party tools might be solved this problem but I am not sure about that.
7 months ago Place Power Query
1.9KViews
0likes
0Comments
Re: Merge taking too much time and refresh is failing
girdharimondal To improve performance and efficiency, I recommend optimizing the right-hand table before merging. Please selectively keep only the essential columns from that table, discarding any that are not needed for the join or final result. Merging all 700K rows with excessive columns may be causing overhead.
7 months ago Place Power Query
2.9KViews
1like
0Comments
Re: Date Slicer Returns Blank Results When Using Dim_Date to Fact Monthly Costs
Here two path you can go: Option 1: If you have two fact tables with different granularities and you are not comparing the two facts, you can use two separate date tables—one at monthly granularity and another at daily granularity. Option 2: If you need to compare the two facts, then aggregate your daily fact table using a GROUP BY to the monthly level and use a single monthly date table for both.
8 months ago Place Power Query
2.9KViews
1like
1Comment
Re: Date Slicer Returns Blank Results When Using Dim_Date to Fact Monthly Costs
jaryszek Curious to know the names of both facts. 1. Are they the same or different? 2. If the facts are different and you want to compare them, the comparison must be done at a monthly granularity. If this is the requirement, I would suggest aggregating both facts at the month level.
8 months ago Place Power Query
3KViews
0likes
3Comments
Re: Date Slicer Returns Blank Results When Using Dim_Date to Fact Monthly Costs
I noticed that your Monthly Cost fact table is at a monthly grain. Therefore, you need to align your Date dimension to match this granularity. For example, if you build a Date dimension for the year 2025, it should contain exactly 12 rows, with each row representing the first date of the month.
8 months ago Place Power Query
3.1KViews
1like
1Comment
Re: How do I erase the "Transform File from ..." Folders?
Random_Number please see query dependencies before deleting anything.....
8 months ago Place Power Query
1KViews
1like
0Comments
Re: Running total
You’re getting this error because you used only the column name [Incidents] in the function. To convert a column into a list, you must use the full TableName[ColumnName] format. Please check the solution shared by PhilipTreacy — it explains the correct approach.
8 months ago Place Power Query
1.4KViews
0likes
0Comments
Re: Data automatically changed
It looks like sorting has been applied either in Power Query (M) or directly in Power BI. Based on your output screenshot, the sort order is being applied from one of those two places.
8 months ago Place Power Query
1.4KViews
0likes
0Comments

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.