Przemyslaw Remin

Przemyslaw Remin has asked 47 questions and find answers to 14 problems.

Stats

About

I like challenges related to Microsoft Power BI, DAX and DAX Studio.

In my free time I design handmade wooden puzzle.

Przemyslaw Remin questions

Initial value of Power BI slicer based on another slicer choice
How to get linear regression model parameters with R transformation step in Power Query
How to count the visible items in a specific field of PivotTable without looping?
DAX percent of total by category
Edit asterisk symbol into list of column names in SSMS by wildcard expansion
DAX lookup first non blank value in unrelated table
How to capture slicer value by DAX measure
Changing decimal separator in VBA (not only in Excel)
DAX REMOVEFILTERS vs ALL
How to delete multiple columns in Excel VBA?

Przemyslaw Remin answers

Range accepts sometimes only semicolons instead of commas
Create calculated tables in Excel 2016 Data Model
Keep only numbers in a string / remove all non-numbers
VBA: How to change the value of another cell via a function?
How to change Excel cell's value with a mouse only?
Setting default values in Data Validation drop-down list
Is there a way to add a callout label to a point in a chart, without using select?
How can I "force" Excel to count page breaks correctly?
Traffic lights in Power Bi which work also for totals
setting different background color for each row power bi