This is great! What if I have a column with email addresses and I want to send the email to the associated emails with the applied dax filter?
@roex005
Жыл бұрын
THIS is exactly what I am looking to do as well
@brigittahegarini7162
7 ай бұрын
You are a life savior. Thank you for this video!
@waynewei3380
Жыл бұрын
Really like the idea of using performance analyzer to get query code.
@vidya7453
6 ай бұрын
its soo good .my work is done but its not show percentage value .for my side its show as number .what to do
@jasondavidsondata
6 ай бұрын
It might need you to wrap a format statement around the number in the power be query. I think I cover it in the part of the video.
@hamzakhalidabbasi2028
Жыл бұрын
The explanation provided was excellent and included a thorough, step-by-step walkthrough 👍👍
@jasondavidsondata
Жыл бұрын
Hi Hamza, thanks for your comment and I'm happy you found the video useful 😀
@AndrewBromley-b3q
10 ай бұрын
Great job Jason. Solid explanations without too much technical talk. Thank you
@jasondavidsondata
10 ай бұрын
Thanks Andrew, glad you found it useful. 👍
@katiebroyles8432
10 ай бұрын
This was super useful and helpful. Is there a way though where I can format the grand total row to appear at the bottom of the other values leading to it?
@Adam_Pagan
3 ай бұрын
Thanks for the great video. Would this method apply to embedding a Matrix as well?
@emrc9777
Жыл бұрын
Wow! Game changer! My mind is spinning thinking of all the applications of this… thanks!
@jasondavidsondata
Жыл бұрын
Glad it was helpful! I was the same when I found out about this.
@ravidathathraya
2 ай бұрын
Thank you for the video. One question - instead of a value in a card visual, can the alert be generated based on a value in a table visual? Meaning if some of the values in a particular column have breached the threshold value
@Morale777
Ай бұрын
Great video I want to do the same project but I want to make a scheduled daily refresh of the report and I want it to send an email daily after each refresh. With the report content included in the email
@WendyWu-t4j
7 ай бұрын
@Jason, a quick question, i have a dashboard with several filters, how can i apply different filters and send mails like this video..is it feasible?
@shaikabbas6048
11 ай бұрын
When i update the data in report next day will the power automate flow will email that updated data or this static data only everytime we run the flow
@yeloSolo
7 ай бұрын
It refreshes with dataset, the DAX will be applied over the dataset.
@bethfollenweider1472
5 ай бұрын
Great video but it's mind boggling how easy this was to do in SSRS and how painful this is in PBI. How is there no tool to solve for this yet?
@ngocnguyen4616
2 ай бұрын
thanks for your sharing. How to delete the grand total row in json table?
@lokeshvardi8723
4 күн бұрын
This helps me a lots thanks Jason
@PrabhatKumar-tn3be
Жыл бұрын
Hi, It looks like that measures do not export, only text content can be exported to csv. Is it possible to export the table with text and measures both, PLEASE? I see the values in "Input" but "Output" shows "null" therefore nothing saved in csv file. // DAX Query DEFINE VAR __DS0FilterTable = FILTER( KEEPFILTERS(VALUES('_____PrerequisitesPK'[Deployment Date])), NOT('_____PrerequisitesPK'[Deployment Date] IN {BLANK()}) ) VAR __DS0Core = SUMMARIZECOLUMNS( ROLLUPADDISSUBTOTAL( ROLLUPGROUP('_____PrerequisitesPK'[Installation Time GMT], '_____PrerequisitesPK'[Batches]), "IsGrandTotalRowTotal" ), __DS0FilterTable, "PK_Dist_Count_Exclude_Offline__14Days", 'Measures PK'[PK Dist.Count Exclude Offline >14Days], "PK_Dist_Count_Offline_Exclude_Offline__14Days", 'Measures PK'[PK Dist.Count Offline Exclude Offline >14Days], "PK_FT_Pending_NOT_on_WiFi_Exclude__4Days_Offline", 'Measures PK'[PK FT Pending NOT on WiFi Exclude >4Days Offline], "PK_FT_Done_Exlcude_Offline__14Days", 'Measures PK'[PK FT Done Exlcude Offline >14Days], "PK___FT_Done_Exclude_Offline__14Days", 'Measures PK'[PK % FT Done Exclude Offline >14Days], "PK_INS_Done_Exlcude_Offline__14Days", 'Measures PK'[PK INS Done Exlcude Offline >14Days], "PK___INS_Done_Exclude_Offline__14Days", 'Measures PK'[PK % INS Done Exclude Offline >14Days], "PK___INS_Pending_Exclude_Offline__14Days", 'Measures PK'[PK % INS Pending Exclude Offline >14Days] ) VAR __DS0PrimaryWindowed = TOPN( 502, __DS0Core, [IsGrandTotalRowTotal], 0, '_____PrerequisitesPK'[Batches], 1, '_____PrerequisitesPK'[Installation Time GMT], 1 ) EVALUATE __DS0PrimaryWindowed ORDER BY [IsGrandTotalRowTotal] DESC, '_____PrerequisitesPK'[Batches], '_____PrerequisitesPK'[Installation Time GMT]
@RohitThakur-ku8sb
7 ай бұрын
You found the solution, plz share as I am also looking for the same
@anirbanaws143
Жыл бұрын
This has helped me tremendously. I am working on the next step of this. Say, automating it for many regions...and if for some region the threshold is crossed, it sends and email to the regional manager of that region only. Similarly for others....
@pavanjaiswel8694
Жыл бұрын
Hi bro, I need some help with the automating data alerts for regions , could u revert back ?
@prasunabhimaraju9075
2 жыл бұрын
Also in select we are getting Column Headers, how to get column values?
@jasondavidsondata
2 жыл бұрын
Hi Prasuna, To get a specific value you can use the approach explained here: kzitem.info/news/bejne/1ZiE3IKhamOki4I The same principle applies to getting specific value from a table. In this video use action to extract the whole dataset so get every table value as in kzitem.info/news/bejne/1ZiE3IKhamOki4I this part of the video. Hope that helps, Cheers, Jason
@yeloSolo
7 ай бұрын
Mate I hope this video is not taken down by tomorrow!
@prasunabhimaraju9075
2 жыл бұрын
thank you for the detailed explanation
@brunomanzi1857
2 жыл бұрын
Thank you, it helped a lot! I will try to work on it. I have a question: I have a table that contains a lot of data, but only a few of them are relevant to send to my manager. So have to take out all "null" values by filtering in that filter area in "filters on this page". When I copy the query for the table, it also applies this filter? I am afraid to send a huge table with irrelevant values. Thanks! Awesome video :)
@jasondavidsondata
2 жыл бұрын
Hi Bruno, thanks for the comment 👍😀 When you copy the dax code for the table visual it should include the necessary code to filter the null values.
@cheelokwong4114
10 ай бұрын
hi Jason, can I ask have you encountered this error before? The variable 'Number of Draft per month' of type 'Array' cannot be initialized or updated with value of type 'Integer'. The variable 'Number of Draft per month' only supports values of types 'Array'.
@arezoomasoud3646
2 ай бұрын
This training is such a miracle! I really appreciate your video, you are my hero! The only subject I wish you covered is about formating the "Date" which is a common problem.
@nurazreenaziman9606
Жыл бұрын
Thanks for the video! but can i understand if this flow will automatically get the updated data from the scheduled refresh that we set in power bi service, and the data will be updated in the table embed?
@jasondavidsondata
Жыл бұрын
Hi, The flow will use whatever data is in the power bi report when it runs. So if your power bi report has a scheduled refresh each morning and you run the flow after the scheduled refresh it will create a table with that data embedded in it. Hope that answers your question. Cheers Jason
@nurazreenaziman9606
Жыл бұрын
@@jasondavidsondatareally appreciate the answer Jason, this video is so helpful!
@healyd5
11 ай бұрын
Thanks Jason, great run through. How would you recommend formatting dates as they currently come through in ISO 8601 Formats. I tried using the formatDateTime function at the select state as below but no luck. formatDateTime(item()?['Source[Date]'], 'MMM ddd yyyy'). Any help is welcome
@luisfernandomacedo1451
7 ай бұрын
Great job, sir! If I wanted to send more than one visual, must I need to add an AND() condition to the logic? I was thinking about sending the columns chart and the table
@shubhabratadey
8 ай бұрын
I have been searching this video for such a long time...🤟 This is such a priceless video and I have literally lost the count I have referred this...💌🤟
@NidhiSharma-gw2qk
Жыл бұрын
Thanks for the video! Very helpful!
@jasondavidsondata
Жыл бұрын
That's great, glad you ground it helpful and thanks for the comment
@andreicostin3
Жыл бұрын
Hello, nice video as usual , do you know guys how to get rid of the blank values working with the same method were should i add another step ? Thank you! :D
@SonaliDhar-j9j
Жыл бұрын
When I run my flow, I could see only header in the email. and values are all null. Could you suggest what could be wrong here. Thanks,
@EPDBerkshire
10 ай бұрын
Hi All, This was a very helpful... How can I display the total row at the bottom instead of the top?
@danielcarvalho2158
Жыл бұрын
Hey @Jason , I was wondering if it is possible to do something similar to this but instead of it being if a specific value of KPI changes it sends to the people we choose, I wanted to drill it down more. So if that value was changed but only because of a specific country then only people from that country would get that email. For example, I have a target of 5 apples per day and only one of the countries goes below that target, then i want only a specific person of that country to get an alert email...
@jasondavidsondata
Жыл бұрын
Hi Daniel, sounds like it should be doable. I'll look at creating a video if I figure it out.
@VanessaSuan
6 ай бұрын
@@jasondavidsondata did you create a video like this? I need exactly the same. Thank you!
@davepoisson2742
Жыл бұрын
Thanks for that one , very helpful!
@jasondavidsondata
Жыл бұрын
Cheers Dave, thanks for the comment 😀
@NicolasErrazuriz
Жыл бұрын
Thank you Jason, excellent video. Can I ask you for help please, Im not able to create the "total" row so that it doesnt show in blank.. thanks in advance
@cristobal7072
Жыл бұрын
How can I applicate a condition in each value of a table if I extract that in a query of power bi?. You used a card, but I need filter a table . Help me please
@charlesorly5536
8 ай бұрын
Awesome! thank you so much, this will be very useful
@VishalKumar-np9bi
Жыл бұрын
Thank You! sir, This video helped me a lot to accomplished what I wanted to do in Power BI and Power Automate. Please make a video on formatting the table cell with different colors based on the values which each cell satisfied.
@jasondavidsondata
Жыл бұрын
Hi Vishal, thanks for your comments 😊. That's a good idea for a video too.
@belenlopezalduncin9278
Жыл бұрын
@@jasondavidsondata Hi, have you done a video on this in the end? I've been looking everywhere. thanks for the video it was very helpful
@jasondavidsondata
Жыл бұрын
@belenlopezalduncin9278 not yet, I'd completely forgot about it. I'll add it to my list though but I'm not sure how long it will take I'm afraid to say.
@bhargavram9790
3 ай бұрын
Helpful video. Thanks a ton.
@bodybuildingmotivation5438
Жыл бұрын
Make more videos on power automate, i love your content😊😊😊
@RohitThakur-ku8sb
7 ай бұрын
Plz help , i can't get values other than month in select step, they all show as null , followed exactly same as shown but can't get it right. plz plz help
@jasondavidsondata
7 ай бұрын
Hi, without seeing more of what you are doing I can't really help. You can ping me a pm on LinkedIn if you want to exchange emails. www.linkedin.com/in/jasondavidson
@RohitThakur-ku8sb
7 ай бұрын
@@jasondavidsondata Hey , I tried and I was able to get it finally, I really appreciate your quick response. I will surely connect on LinkedIn. Thanks again 🙏
@cristobal8336
Жыл бұрын
Nice, but how can I filter by a value when a value of table will be X for example?. I have a lot of rows, but I need to know how can I send a email when a value of row in that table equals X value.
@niranjanmakkuva4639
Жыл бұрын
Is there a way to add the report as xlsx attachment instead of link
@nivethak5116
Жыл бұрын
how did you get ('Get_YTD_Cost_vs_Budget_Pct_Value')?['body/firstTableRows'][0]?['Total_Cost_YTD_vs_Budget_YTD_Diff_]'] Could you please explain how you got this expression?
@hyabhi
10 ай бұрын
Seriously need help to understand this output stuff at 5:54 that is being used as target value. Any help is much appreciated.
@bharathharishkumararumugam1621
Жыл бұрын
Like that i want to sent multiple tables in mail in a single report
@7MoOdii86
Жыл бұрын
How to do This in power bi desktop?
@samcrowson167
Жыл бұрын
This is a great video! Thank you
@DominicDion-u8n
Жыл бұрын
Hi !!!! Tihis is an excellent tutorial !!! Seriously, saved me a lot of time. I have a question though... The grand total goes at the first row (just under the column headers) of your HTML table example... Is there a way to move it at the bottom ? I know the HTML code to format the last row... but right now my grand total aren't the last one. Thx in advance.
@DominicDion-u8n
Жыл бұрын
I found it !!!!! Just need to change the DESC to ASC into the Dax Code at section ORDER BY at the bottom : [IsGrandTotalRowTotal ASC,
@astralyog
Жыл бұрын
Fantastic!
@jasondavidsondata
Жыл бұрын
Cheers, glad you found it useful. 👍 😀
@zdeneknovak4350
Жыл бұрын
Very nice!
@JeffHenscheid
Жыл бұрын
This is great and appreciate the stepping through the process. I am using Fiscal Week instead of Month and am having trouble sorting by the fiscal week number. Any tips to do that? Thanks
@NicolasErrazuriz
Жыл бұрын
Hi! Im having trouble sorting also the tables, have you had any luck? tips to share? thanks
Пікірлер: 79