Forum Discussion
commission schema
Hi TAZ95 ,
What does your expected result look like?
If you want to filter based on month and ID, you can use slicers.
Slicers in Power BI - Power BI | Microsoft Learn
In Power Query, you can use the group by feature.
Grouping or summarizing rows - Power Query | Microsoft Learn
In DAX, learn about FILTER function to apply custom filter.
FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations - RADACAD
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi TAZ95 ,
What does your expected result look like?
If you want to filter based on month and ID, you can use slicers.
Slicers in Power BI - Power BI | Microsoft Learn
In Power Query, you can use the group by feature.
Grouping or summarizing rows - Power Query | Microsoft Learn
In DAX, learn about FILTER function to apply custom filter.
FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations - RADACAD
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.