The last month and last quarter is not working correctly for me. It is showing last years last month (dec 2019) data while my end date is oct 2020. Any idea what might be wrong? The filter for date range is fine which is from Apr 2019 to Oct 2020. ADDCOLUMNS(PREVIOUSMONTH(DATESYTD(DimDate[Date])),"Type","Last Month", "Order", 4)

thank you so much

I am trying the same but Power automate is showing "feature not found" I have premium per user

TYSM. You help me a lot

So if there are 23 categories which need to manually sorted, you will have to key in 23 numbers. There should be an easier way out in the tool, which apparently isn’t available. Tableau and excel is simply drag and drop

Hi ,after getting data when i refresh the data i am getting the error like Access to the resources is forbidden ,is there any other option to do the same job Thanks in advance

Great solution but I'm not able to use the last option :( When I add a measure to the slicer, range disappears and the slicer becomes "greyed out". I followed each step that was presented in the video. Has anyone had the same issue and solved it somehow?

Found the content very Helpful !

I'm trying to do the same for bar chart, where Y is defined my SUM measures and X by dates. Each month on the chart has 3 bars - Sales of current year, plan of current sales and how sales in the month looked in previous year. Do you have some idea how to filter bars with slicers? I need to show every 3 bars, sometimes 2 of them and sometimes only one.

Thank you for providing this simple and perfect DAX, hope will get more helpful videos.

great video, thanks for the help

saved the day brotha! keep em good contents coming!!

Thank you for this. Very helpful

I am looking for a solution for something, if you can help me I will be greatfull to you, there are 2 tables, table1,table2 both contains invoice number as text, need to check the table invoice_number exist in table 2 invoice_number by available 'Yes' or 'No'

the violin plot reminds me of something, kinda familiar look.

You saved me! literally! Can't thank you more!

How to deal the data which is coming in PST format dd-mm-yyyy hh:mm:ss but Power BI dashboard in IST format. Have to present the data in PST format itself along with day light saving without using external api

Thanks a lot)

Perfect. Thanks, been trying to do this for more than 4 days now.

Awesome, are their are more simple method?

Hi Parker, Thanks a lot for your fantastic REST API video series. Your videos and channel are a wealth of knowledge, and I have implemented the solution for my organization and works great except the Access Token generation part that I failed to replicate as per your instructions. However, I have done a simple trick way of copying the Bearer token to a Parameter from Microsoft Learn website manually and everything works wonders for me now. Would be great if you re-do a video for that Bearer Token generation as I think due to 2 factor Authentication the azure app fails to give the right response to the api call.

Hi, I created all the fields but I'm running into issues with fields with text data. Ideally I do want to find correlation between different text paramters between different fields. Example - is there a positive correlation between 3 types of glasses Vs 8 types of cocktails. How would you recommend using the correlation formula for qualitative data?

Thanks

What if you have to do with 2 numerical fields?

It's end of 2024 and they still have the same issue...Thank you for the video though, was really helpful!

Hmmm. I tried this but it doesn't quite work for me - the filtering does, but the "disable" for the custom range doesn't - it doesn't grey it out, it doesn't prevent the user clicking the calendar icon and changing a date ... have I missed something?

This is a really great tip, thanks for showing us. One critique: you're way too fast. Slow down! Sidewalk's for regular walkin' ...not for fancy walkin'.

Thank you, though I think there should be an easier way of sorting these columns, right? It looks quite complicated. What if I want to change the order? Can I edit this table I just created or do I have to create a new table with a different order? Thanks

THANK YOU SO MUCHHHHHHH

Bro... you saved me with this, huge thanks! Otherwise I would have to learn Python to build this, and I am waaay to busy to tackle that right now. Besides, I am not even a data analyst, learning Python is above my paygrade.

What a gigachad, thanks for the solution

Very useful information 🎉

Thanks a lot. Was looking for it to get a solution.

THANK YOU SIR, helpful video, but I have Premium per user license, it doesnot work... any solution for this.

love it man! tks

The first example is recursion to be quite precise.

Hello , upon refreshing the report I am getting an error on the timezone table that says " The underlying connection was closed. The connection was closed unexpectedly" . How can I fix this issue ?

Awesome! Just what I needed!!

wow, this is really a very valuable tip. Thank you. Keep up the good work.

Thanks Parker!! 😀

Good value of 3 min time

I cant find the visual in the market :(

Thank you for this and the example, I am trying to adapt this now to a rate limited API.

Hi, I have tried and range slicer is working fine. But I have a card visual which shows the ID count which is not changing with the range slicer. Could you please assist?

You helped me out! thanks !

Just wow

You literally saveeeed me,many thanksss!

This is a thing of beauty!

I really appreciate you as it's helpful for me!

Thanks. It actually works to me