Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Date hierarchies aren't working in DirectQuery Mode, but are working in Import mode. Please help
@Anonymous ,there can be a few reasons.
You might have switched off auto date time at file level (In options and Setting -> Options )
Joined these dates with a date table
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
Check Settings
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
I always prefer a date table and not the auto date time hierarchy
Hi @amitchandak I need to rank sales, by item, by store number, is this possible? I.e. Top selling items by store
I.e: StoreID, SalesQty, ItemNumber
Store 1 sales 52 item a = Rank 2
Store 1 sales 187 item b = Rank 1
store 2 sales 91 Item a = Rank 1
store 2 sales 36 Item b = Rank 2
Store 3 sales 87 item a = Rank 1
Store 3 sales 31 item b = Rank 2