Provide multiple column Join functions and different Join cardinality
When we set relationship, only can be performed for a single column in PBI Desktop. i think PBI can provide multiple column Join functions and different Join cardinality (= , >= , <= or between) in the future.
Set the join type in the relationship
i know we can use merge table to complete the table join (like left join, right join, outer join..etc )in the Query editor now. If we can directly set the join type , even self join in the relationship, the function will be better.
we can set “Don’t summarize” for the field after the DAX calculation or the calculated Ratio field
For the Measure Cloum we can set “Don’t summarize” in the Report Design. But we can’t set “Don’t summarize” for the field after the DAX calculation or the calculated Ratio field. Ex : Summarize “cumulative achievement rate”filed, I can set “Don’t summarize”in the total column or the value can ...