Hi i need some help with getting QoQ and Month on month variance but my data contains multiple hundreds entries for single month , how should I move forward with creating a calendar table for this type of data . ( eg: july has 500 rows)
Hello, having multiple entries in a single month is actually very common, but it shouldn't matter! So I would follow these steps 1. Create a calendar table with unique dates, 1 row 1 date 2. Create a relationship between your table and the Calendar 3. Create a measure to aggregate your values (sum, count) this should return your month totals 4. Create another measure to calculate your variances, referencing no. 3 in your Calculate Good luck!
I find your videos very informative especially with custom visuals. Thank you
Great video - provided just what I was looking for!
This is amazing bro! This is exactly what I needed.
This is very helpful. Thanks!
thank you, this channel very helpful for my job
Thanks. That's What I was looking for.
Hi! Thanks a lot for your very clear explanation. These search solutions are very useful and easy to implement in BI. That's What I was looking for.
Amazing my bro!
Thank you so much brother
2:41 option removed from latest version. Please help
have you found the resolution ?? i am not able to find search bar
thanks, this was helpful
Thanks this is very informative, is there a way to use the search bar to jump to another page?
Omg thank you so so much
Thank you!
Nice one mate. Really useful
Really useful 👏🏼
Thank you
Need search bar for number and date data type columns.
Is there a way to make it that if the search bar is empty to not display any data?
Thanks for sharing. =)
thanks, but how can I search in all fields, like google search, and with autofill or intellisense, this would be great
Nice one 👍
Thanks for sharing. Is it possible to save the User input into a variable. So that we can do some conditional formatting based on the search text?
Thanks for the video. please help me- if the search bar is empty then the table should be also empty.. how to do this? please help.
awesome thanks
Hi! Is there wa way i can implement the search bar but result should show the exact value not just part of the string?
Thanks, click on a video and get what you need. Great video - How they all should be!
Hi i need some help with getting QoQ and Month on month variance but my data contains multiple hundreds entries for single month , how should I move forward with creating a calendar table for this type of data . ( eg: july has 500 rows)
Hello, having multiple entries in a single month is actually very common, but it shouldn't matter! So I would follow these steps
1. Create a calendar table with unique dates, 1 row 1 date
2. Create a relationship between your table and the Calendar
3. Create a measure to aggregate your values (sum, count) this should return your month totals
4. Create another measure to calculate your variances, referencing no. 3 in your Calculate
Good luck!
@@SolutionsAbroad thank you for the information 🤝🏻
Is there a way I can search Visual / Table names via search bar instead of Columns
I have 2 text filters, is there a way to automatically clear the 1st text filter if searching using the 2nd text filter and vice versa?
How to search the list of values in slicer
La búsqueda no es tan exacta!! descargue el app y presenta errores al filtrar.
Search option is no longer available so this video is useless.
Not easy to use at all! Worse than search function within slicer