Video

Hi Can you please share this dataset. I have mailed you yesterday

RANK By Year and Sales = VAR vRelation = ADDCOLUMNS( SUMMARIZE( ALLSELECTED(Sales), 'Date'[Year],'Product'[Category] ), "_Sales",[Sales Amount] ) VAR Result = RANK ( DENSE, vRelation, ORDERBY ( 'Date'[Year], ASC, [_Sales], DESC ) , PARTITIONBY( 'Date'[Year]) ) RETURN Result gives same Result 1 in a matrix with 'Date'[Year],'Product'[Category]. Sales Amount = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] ). Could you share file please

My problem is that in my version of Power BI, the 'Data Colors' command is not available, so I don't know what alternative to use. Which version of Power BI has this command?

Awesome. Could you please make a video on how to use Rank to sort based on a list of values? Eg rankx -- The third argument of RANKX is useful when the outer -- evaluation requires a different expression than the -- inner one. For example, when ranking an expression over -- a pre-built lookup table DEFINE VAR SalesLevels = SELECTCOLUMNS ( { 6000000, 3000000, 1500000, 750000, 0 }, "@Limit", [Value] ) EVALUATE ADDCOLUMNS ( VALUES ( Product[Brand] ), "Sales Amount", [Sales Amount], "Level", RANKX ( SalesLevels, [@Limit], [Sales Amount] ) ) ORDER BY [Level] ASC 2. How to do approximate match lookup in powerbi

Very creative, but DAX and audio explanations are too fast to grab and understand. I have to rewind several times to get the concept. Anyway, great video.

can you share the dax code here?

Thank You for the solution video , I have also mailed for this query, But in my scenario only one year is showing, Please tell what to do ?plz reply

Very useful information

Thanks for your video! But I have 1 question: If I have a lot of report in my workspace and I want to monitor all historical status of them, how can I do it? Because I see we input the group_id and dataset_id, with 1 report just has 1 dataset_id

Amazing! really helpful!

I tried this approach but it didn’t work .please help me

😮 Thank you 🙏

Hi .i am getting error...it says the sort can't be done as there are multiple values associated.can u pls help

does this also work on a stacked bar chart?

So stupid that something as simple as this and show N periods in a visual isn’t just an option.

Thanks for the video. Similar to how there is the “forecast” extension to the actuals, it would also be nice to see trend (sounds similar to forecast but in my world, the trend is different. Forecast is human input and can always be much higher). Also an extension or a whole different line for budget. And a way to evaluate the forecast vs budget by + or - 1,2,4 percent

So I have a power bi report user. If this report user clicks refresh, would it be possible to trigger the API to put updated data down to the report?

It isn't streaming dataset it is simple dataflow.

Thank you for your help! I have 1 question: when I got to the very end to check, my month is sorted alphabetically instead of Jan Feb Mar etc. do you know how to fix this?

I was trying to create a similar logic but it did not work, compared to you I did it a filter for the past one year, like if I select this year from a slicer, it was supposed to show previous year : New OPEN requisition = VAR _fromdate= IF ( Selectedvalue('Past/Future'[Past or Future])="Past", MAX(NEWDATET[Year]), Min(NEWDATET[Year]) ) VAR _pastfuturemonthshift= SELECTEDVALUE('Past/Future'[Multiplier])*MAX('No. of year'[No. of year]) VAR _periodshift= DATESINPERIOD(NEWDATET[Year], _fromdate,_pastfuturemonthshift, YEAR) Return Calculate( [Open Requisition], REMOVEFILTERS(LU_Calendar), KEEPFILTERS(_periodshift), USERELATIONSHIP(LU_Calendar[DateValue_DATE], NEWDATET[DateValue_DATE]) )

Super! Thanks!

Sir I have tried Measure formula as I have seen but it doesn't show the sum of the selected column in visualization in Graphical way. It says that Couldn't load data for this visual because MDX model script (3, 36) calculation error in measure. What can I do? Please reply

Great video but you are very fast 😅 or I am getting old and slow.. Thanks a lot for sharing.

Long time not update videos😀

Thanks, save my day!

Great ❤

Always on the lookout for your videos, awesome, thanks.🎉

My forecast value is empty(Can't figure what's wrong.

Sir How can we find Duplicates in Poer BI.

Good work 👍

Cool One after a break 🙂 ...

Please share the file use.. email sent thank you

Rank value is not coming when we add into matrix

without tabular editor can we do this

Why do you make the connection between two tables "one to many"? i guess it is wrong as we have only distinct values in both columns!

Awesome thankyou. I was doing it in the query instead of the transform data table

this video just earned a new sub. thank you!

Getting this error - Current vs Previous[Previous_totalsales]: dax comparison operations do not support comparing values of type text with Values of type number

but how will it take input from front end if I give to the user?

how to make it automatically detect the Item code and system time and datae and user email. I just want them to add comemnts and they cant edit the date time, email or item code? I have tables having relationship based on Item code?

This is really helpful, thanks a lot.

Waoooo

This video is awesome. Thank you so much for sharing. Could you please let us know can we use AD group to capture login user. Our CEO does not want to see few fields but other employee need to see all the fields. Please suggest with this example.

Hi Thanks for the video I did exactly as the video the power bi and the txt file are in shared network I managed to refresh the power bi file but when i change a step in the txt file and try to refresh it from another computer which has the same level of permissions as mine it shows me an error message Invalid identifier Is there any solution for it

Can you please tell me that how you used the emojis in the titles

Column header is not changed in your video?

Your Content is Uniqueness!! Please make more video on dynamic DAX because most of interviewer will ask this type of question

super video ..!! Thanks for sharing.

what is [Total Amount] in the dax measure?

ProgBar visual gives automatically gives this, we don't have to create it