Hi @Simon Lamb Thank you so much! I'm too bad at DAX :( I am using your 2nd calculated column method since I need to visualize in a bar chart, and it works perfectly. ------------------------------ Zhang Haoran ------------------------------
I am trying to calculate and show percentages in a matrix view in Power BI. I am using two data fields as shown in the example below; total medical and preferred suppliers. I need to calculate the percentage (adoption %) for each state such as New Jersey ...
Hi @Zhang Haoran , If your table is called 'Table1' then you can write a measure to calculate Age: Age = CALCULATE ( COUNTROWS ( Table1 ) , FILTER ( ALL ( Table1[Date] ) , Table1[Date] <= MAX ( Table1[Date] ...
Thanks Chandreshsinh, Sam and Ryan. Sounds good, we were thinking to have two people on our team to publish our pbix files for now. I wanted to see if i could go ahead and create the reports and they could publish for the rest of us. Have a good week, ...
Hi @Abhi K , To get the value on the last day of the month the measure would be something like: Value on Last Date = CALCULATE ( AVERAGE ( Data[VALUE] ) , FILTER ( Data, Data[DATE] = MAX ( Data[DATE] ) ) ) If you put ...
Hey, all! Your user group website has some new and changed features, and I’ve highlighted some of them below. View your Followed Content For some time now, you’ve been able to follow discussion posts, blog articles, and library entries by ...