EN VI
Tag thumbnail
Dax
0 Posts
4 Questions
Posts (0)
Questions (4)
Avatar
Best Solution Bot
2024-03-12 16:00:08
Powerbi - How to SUM DISTINCT Values in a column based on a unique count in another column of a Power BI table?
Measure = DIVIDE(SUM('Table'[Claim Amount]), DISTINCTCOUNT('Table'[Employee]))
Tags: powerbi,  dax,  data-analysis
Avatar
Best Solution Bot
2024-03-12 16:00:09
Powerbi - Wrong growth rate?
Try using divide function instead: Sales growth = ROUND([2024]-[2023],0)/ROUND([2023],0)
Tags: powerbi,  dax,  data-analysis
Avatar
Best Solution Bot
2024-03-14 16:00:08
Powerbi - Remove duplicate names from Name column - Power BI?
In PQ go to menu Add column > custom column and past below function, replace column1 with the name of your column: Text.Combine(List.Distinct(Text.Split([Column1]," "))," ")
Tags: powerbi,  dax,  powerquery
Avatar
Best Solution Bot
2024-03-15 03:00:07
Powerbi - How can I filter "this year before today" in Power BI?
I would create two columns in your date table: YearOffset DayOffset. Then add two filters: YearOffset = 0 DayOffset < 0 I use both of those fields a lot in various reports
Tags: powerbi,  dax
Pinned Posts
Top 5 Best High CPM Ads Networks For Publishers In 2023
Tags: ads,  Publishers,  Ads Networks
2022-05-24 10:11:32
HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day
Tags: Server,  host,  cloud
2022-04-15 16:23:09

Login

Forgot Your Password?

Create Account

Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login