Power Bi Interview Question: Calculate Unique Combinations of Two Columns| Distinct Count| Q62

[@workstuff5253]

Because you listed the Sales table in the SUMMARIZE function, are the group by columns coming from the expanded table (sales)?

[@AmitChandak]

They are coming from two dimensions, which is why I have used a central fact table.

[@shoeb1359]

One question recently faced in interview How to create a single date filter from 2 different date filter of a same table( example: start date column & end date column)

[@AmitChandak]

Please check, if these can help. Userelationship with Inactive joins can help Power BI: HR Analytics - Employees as on Date : kzbin.info/www/bejne/m2e8Xp-Vf9l2p5Y community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970 Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: kzbin.info/www/bejne/nKfKlKtuhrGkkLc