I am having quite a similar data set, but getting following Expression.error "we cannot convert a value of type list to type table". Any idea which why it's not detecting _ as the table, but as list? Thanks in advance for your support!
Hi, I am trying to do something similar but I cannot transform data in the query because I have to use the data for other measures. Can you show how to do the exact same thing using Dax measures?
Thanks for your share. It helped me on a project. Need your help on one more thing. Can I able to generate the distinct count as running count? Instead of 2, it should reflect as 1,2.. and for 3, it should be 1,2,3.
when you group the data, you are changing the granularity. you are combining some rows based on values of a column, so they will be aggregated. if you still want other columns, then you have to include them in the group by key columns
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase. So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
Man that a big relief 😢 thx it’s like a year searching for that 🎉
I'm glad it helped! 😊
This was the answer ive been looking for all day! thanks!
Hii, It's very very Helping for me.... Thanks for this.....
Easy teaching easy learning. Thank you.
Thank you for such a helpful video. I enjoyed learning this for a project I am working on right now!
Glad it was helpful!
amazing content
Thanksss! this is exactly what i was looking for
Glad I could help!
Thank you! Very easy to follow and works!
Thank you so much. it helped . can we get the data by year in this?
I am having quite a similar data set, but getting following Expression.error "we cannot convert a value of type list to type table". Any idea which why it's not detecting _ as the table, but as list? Thanks in advance for your support!
Is there a way to list only LATEST records from a table using that?
Thanks this solved my issue but why Microsoft couldn't just include the option in the drop down in the first place.
Hi, I am trying to do something similar but I cannot transform data in the query because I have to use the data for other measures. Can you show how to do the exact same thing using Dax measures?
Hi did he ever reply? I am looking for the same solution
Thanks for your share. It helped me on a project. Need your help on one more thing. Can I able to generate the distinct count as running count? Instead of 2, it should reflect as 1,2.. and for 3, it should be 1,2,3.
how to change to avoid counting blank. I used the same formula, but its counting blanks. Thanks
Hi Sir,
How can we differentiate Distinct and Unique values normally we can view it in column profiling.
Thanks
After clicking group by, Why the other column hides and does not show up? I want to keep all the other columns of the table. Any solution to it?
when you group the data, you are changing the granularity. you are combining some rows based on values of a column, so they will be aggregated. if you still want other columns, then you have to include them in the group by key columns
@@RADACAD Thank you for your reply. I'm new in Power BI and learning new stuff. I will try this and hope it solves my issue!
Sir, pls guide me to do indexing based on two column. Ex ... A. India - 1, and it gives 1 whenever A. India comes together.
How are you able to use Table.RowCount which accepts a table with List.Distinct which returns a list?
= CALCULATE(DISTINCTCOUNT('Estado de OT'[Orden]),FILTER( 'Estado de OT','Estado de OT'[Estado De OT] "Cerrada")) ejemplo
Dear sir i want m code apply how to apply =if(a2=a3,0,1) this formula a column i want to apply for uniq count how to apply if condition
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase.
So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
Excelente