Видео

Hello sir , try with same dax function but getting error like The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. following is the dax function MTD_YTD_QTD_Selection = VAR TODAYDATE = TODAY() VAR YearStart = CALCULATE(STARTOFYEAR(SalesTimeline[Date]), YEAR(SalesTimeline[Date]) = YEAR(TODAYDATE)) VAR MonthStart = CALCULATE(STARTOFMONTH(SalesTimeline[Date]), YEAR(SalesTimeline[Date]) = YEAR(TODAYDATE), MONTH(SalesTimeline[Date]) = MONTH(TODAYDATE)) VAR Result = UNION( ADDCOLUMNS(CALENDAR(YearStart, TODAYDATE), "Selection", "YTD"), ADDCOLUMNS(CALENDAR(MonthStart, TODAYDATE), "Selection", "MTD") ) RETURN Result please help me to resolve error

hello, which visual did you drag the selection dax measure to?

Thanks bro nice

Hi Praveen, Just a quick question: If RLS has been implemented, how would the email functionality work? Can we somehow make this dynamic so that whoever is accessing the report would only get the CSV file sent to their corresponding email address? Thanks.

Best video of your channel 😊

I attempted to make a specific visual disappear based on the selection of the year 2023 in my numerical data, but encountered an error. Can you please provide guidance?

Something out of the box... Kudos 🎉

getting error

can we use YTD & MTD function directly instead of startmonth & year function !

👍

Apply all filter button is really a gamechanger when it comes to huge data to be display on any sheet!

Hi Sir, thank you for your sharing. The method is really simple and clear. However, this slicer seems doesn't work on visuals that contains last year's data. I have a clustered column chart that contains this year and last year's column. When I click the slicer, it works perfect with this year's column, but last year's column just disappear. Do you have any suggestion to fix the problem? thank you very much

Promo_SM 😠

Very well explained sir🙏

Very informative

Good job keep going

How do you do that moving bar along the top???

Hello sir, while importing data from sql to power bi it shows me an error18, or host credential error how to solve it, i tried a lot but still it shows me error.

Whatta amazing explanation.

Very good vidoe

🙌

👏👏

Wow, the way you explained is very crisp and clear

Hiii bro ,are you given any support on power bi

👐 informative

Informative

Nice 👍

Nice 👍

Amazing, very well explained

Thank you Field Parameter knowledge. I'll use it.

👌

Nice

Nice 👍👏

🔥🙌

🔥

Nice 👍

It's clears my doubt. Thanks for this video.