Forum Discussion
Power BI Matrix Viz Dispay help
Hello Every One . Good Morning I have an issue on how the below format can be acheived in Power BI Matrix viz or another type of viz that could help me resolve the issue ,Below is the layout and ...
v-gizhi-msft
Community Support
Community SupportHi,
Please try to create this calculated column:
Overall Status = IF('Table'[ScheduleDate]<>BLANK(),CALCULATE(MAX('Table'[Datediff by day]),ALLEXCEPT('Table','Table'[Country Name])))And it shows:
Here is my new test pbix file:(I have made a bit changes to original data)
Best Regards,
Giotto Zhi
Hello
For me approvals are coming dimension approval
country name from country dimension
actual schedule dates from fact
i have written like this if(scheduledate<>blank()),calculate(max(diffofdates),allexcept(country,countryname)) it throws me an error
and also overallstatus should not get repeated in the layout
Thanks
Kalyana