Forum Discussion
AlanP514
3 years agoPost Patron
WTD
Hai All,
I need to achive two scenarios
1: I Have time intelligence slicer , and working in the WTD
So requirment is under WTD W1 to W4 should be there but it should be dynamic for eg .in the above image i have selected 2022 october , in the selection actually 5 weeks is there, so my time intelligence wtd weeks also should populate based on that
2: WTD Calculation
i have a sales measure in pbix ,
scenario if user clicked on w2 october 2022, i need to create new measure and output should be aggregation of both w 1+ w2
and it should be dynamic with above 1 st scenario
i am attaching the PBIX file aswell
1 Reply
- lbendlinSuper User
Weeks and months are incompatible. Your calendar table is missing an explicit "Week in Month" column.