Відео

FYI the middle "Apply to each" loop action is unneeded... it can be deleted with a direct connection to the prompt!

thanks for this

Greetings, Click on "Update model with Changes" next to RUN and all the changes will be updated simultaneously.

I have a composite model, with one table using AAS as a live connection and another table imported from SharePoint. When I create a relationship between these tables, it results in a weak relationship. When I try to change the storage mode of some tables to dual mode, the option is grayed out. How can we avoid the weak relationship using the dual model option?

Very nice. Thank you sir!

Thanks for this Tutorial ... Always provide the dataset for us to follow along and that will help your channel to grow ...

thank you so much! so helpful for me!

Please keep this up! Subscribed!

Thank you. I loved this tip!

Thank you for the video, great stuff

If we select anything in date range in PowerBI Desktop before publishing then it will be saved with those selections. I think one of the options to reset to maximum range it is to switch into "After" mode and then to "Between" and save it.

MFSTA REALLY. Needs to fix this because I don’t want current period I want the month. They just need to add default options

thank you! working good...but how I can do to allow it only to xlsx files?

But imagine I want to close the dashboard with some date, but when I open the dashboard I want to display the current date. Is that possible?

thank you, I think you explained it really well.

Awesome! =)

Good video dear 👍

Side note I’ve also tested another way for ensuring the end date updates through yesterday or today. In this approach, you can use any date field from fact or dim table and use the “in the last” relative date approach at the page or report level. Combine it with a “is on or after” a specified date if you don’t want anything related to the start date to change in your report.

very useful video!

Thank you! Really good my dude!

Where do you license your intro music from?

Thank you for this. I was working on these today. I'm a newbie to this and struggled my way through but I will go back and use your formulas.

For anyone curious how to automatically update a 'between' date slicer, check out my solution here! ua-cam.com/video/1_qjZwpUtmg/v-deo.htmlsi=QVaPRF-zDViNH2zy

DAX: Order Date (DIM) = VAR Dates_Var = CALENDAR(DATE(2021,1,1), TODAY()) VAR Calendar_Var = ADDCOLUMNS( Dates_Var, "Year", YEAR( [Date] ), "Month", FORMAT ( [Date], "mmm" ), "MonthNumber", MONTH( [Date] ), "YearMonth", YEAR( [Date] ) & "-" & FORMAT ( [Date], "mmm" ), "YearMonth2", FORMAT ( [Date], "mmm" ) & " " & FORMAT ( [Date], "'yy" ), "YearMonth3", YEAR( [Date] ) & "-" & FORMAT ( MONTH ( [Date] ), "mm" ), "StartOfMonth", MONTH([Date])&"/1"&"/"&YEAR([Date]), "Quarter", FORMAT( [Date], "\QQ" ), "YearQuarter", YEAR( [Date] ) &"-"& FORMAT( [Date], "\QQ" ), "Day of Week", FORMAT ( [Date], "ddd" ), "WeekDayNumber", WEEKDAY ( [Date] ) ) RETURN Calendar_Var M: let Source = #date(2021, 1, 1), #"Converted to Table" = #table(1, {{Source}}), #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type date}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "StartDate"}}), #"Added Custom" = Table.AddColumn(#"Renamed Columns", "EndDate", each DateTime.LocalNow()), #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"EndDate", type date}}), #"Added Custom1" = Table.AddColumn(#"Changed Type1", "Count", each [EndDate] - [StartDate]), #"Changed Type2" = Table.TransformColumnTypes(#"Added Custom1",{{"Count", Int64.Type}}), #"Added Custom2" = Table.AddColumn(#"Changed Type2", "Custom", each List.Dates([StartDate], [Count] + 1, #duration(1,0,0,0))), Custom = #"Added Custom2"{0}[Custom], #"Converted to Table1" = Table.FromList(Custom, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Changed Type3" = Table.TransformColumnTypes(#"Converted to Table1",{{"Column1", type date}}), #"Sorted Rows" = Table.Sort(#"Changed Type3",{{"Column1", Order.Descending}}), #"Renamed Columns1" = Table.RenameColumns(#"Sorted Rows",{{"Column1", "Date"}}), #"Inserted Year" = Table.AddColumn(#"Renamed Columns1", "Year", each Date.Year([Date]), Int64.Type), #"Inserted Month Name" = Table.AddColumn(#"Inserted Year", "Month Name", each Date.MonthName([Date]), type text), #"Inserted Month" = Table.AddColumn(#"Inserted Month Name", "Month", each Date.Month([Date]), Int64.Type), #"Inserted Start of Month" = Table.AddColumn(#"Inserted Month", "Start of Month", each Date.StartOfMonth([Date]), type date), #"Inserted Quarter" = Table.AddColumn(#"Inserted Start of Month", "Quarter", each Date.QuarterOfYear([Date]), Int64.Type), #"Added Custom3" = Table.AddColumn(#"Inserted Quarter", "YearMonth", each Number.ToText([Year]) & "-" & (if [Month] >= 10 then "" else "0") & Number.ToText([Month])), #"Changed Type4" = Table.TransformColumnTypes(#"Added Custom3",{{"YearMonth", type text}}), #"Inserted Week of Year" = Table.AddColumn(#"Changed Type4", "Week of Year", each Date.WeekOfYear([Date]), Int64.Type), #"Inserted Day of Week" = Table.AddColumn(#"Inserted Week of Year", "Day of Week", each Date.DayOfWeek([Date]), Int64.Type), #"Removed Columns" = Table.RemoveColumns(#"Inserted Day of Week",{"Day of Week"}), #"Inserted Day Name" = Table.AddColumn(#"Removed Columns", "Day Name", each Date.DayOfWeekName([Date]), type text) in #"Inserted Day Name"

Great video!

So glad I found this before I finished my current project!

What about a dataset with a live connection?

you deserved more subscriber! thank you

Note the third party visual "Image Pro by Cloudscope" indicates that a license is required, but once I publish to the Service it seems to work fine without one. This allows for much more customization around the image sizing, whereas the table or matrix is limited in this way.

Very Information video, if you have provided the excel and pbx file it will be useful for us to practice and learn.

Very basic solution

you are a life saver

Excellent❤👍

Thank you for that video 👏 Do you know how to apply it to a ”between” slicer? For example last week I wanted to have on my slicer a period 01.01.2024-31.03.2024 as a default period, but today it should update to 01.01.2024-30.04.2024 as default. How to obtain that?

Brilliant!

👍❤

Oh wow, so informative! Thank you Mr. Jacob

finished watching

A note on solution # 3 (DAX measure): The below DAX formula will return the accurate results within the rows of a matrix or table, while displaying blank cells for the ORDERNUMBER and ORDERLINENUMBER results. However, the total at the bottom of your matrix or table (or total if you are using a card) does not exclude order # 10107 with the grouped negative value due to how the evaluation context is handled, resulting in an incorrect total. This is where I got stuck and was unable to build all the logic into a single measure. TotalOrderSalesMeasure = var sum_sales = calculate ( sum ( sales_data_sample[SALES] ), ALL (sales_data_sample ), GROUPBY(sales_data_sample, distinct_sales_data[ORDERNUMBER]) ) return if ( sum_sales > 0, sum ( sales_data_sample[SALES] ), "" )

Nice job

Inspiring video. Online certs are the bomb! #hailstate

Great video!

Thank you Jacob.