Przemyslaw Remin

Przemyslaw Remin has asked 45 questions and find answers to 13 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

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?
Setting zoom without select in Excel VBA
Why SQL changes the exact datetime by one tick

Przemyslaw Remin answers

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
Index by category in Power BI equivalent to SQL row_number over partition