User Profile
GettingStarted
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Default date range for date slicer
Power BI really needs to have a default range for date slicers. It is almost impossible to achieve this in the current settings. For example, it would be beneficial to create a slicer, add dates from a calendar whether it be sales dates, created dates etc, then be able to set a default date range (eg Jan 1st - April 1st). Once the default date range is set, then users are still able to filter the date range (eg Jan 1st - Dec 31st).470Views0likes1CommentRe: Power BI count email addresses where some are duplicate and some are blank
Thanks for your help, I really appreciate it. It still doesn't seem to be working as it's only counting the unique value. [email protected] [email protected] [email protected] Total Emails = CALCULATE( COUNTROWS(table), table[email] <>"null" ) returns a value of 1 instead of 3. It's weird so maybe there is something I'm overlooking...1.1KViews2likes1CommentPower BI count email addresses where some are duplicate and some are blank
Hi all, It would be awesome if I could get some help with this as I'm quite new to Power BI. I'm trying to count email addresses if they are not blank/null but I don't know how to get the correct result. Example: number email 1234 [email protected] 5678 [email protected] 1213 [email protected] 1415 null 1617 [email protected] My measure is: Count Email = COUNTX (table1, [email]) This results in a total of 2 email addresses but I need it to be 4. I'm not sure why this is so hard for me haha. Any help is greatly appreciated if possible. Thanks!1.2KViews0likes3CommentsRe: Power Automate Run Query Against a Dataset Syntax?
I know this post is getting old now but I stumbled across it looking for the same thing. To quickly and easily generate a dataset query, you can do it from inside Power Bi and copy/paste it into Power Automate, or wherever. 1. In Power BI click on "View" > "Performance Analyzer" 2. Click "Start recording" 3. Refresh your data by clicking "Refresh" 4. Click "Stop recording" 5. You will then have a representation of your data (mine was in a table), so click the "+" next to it then click "Copy query" and paste it wherever you need it. Very fast and most importantly - accurate!29KViews2likes0Comments
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.