Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
3 years ago

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

  • Weeks and months are incompatible. Your calendar table is missing an explicit "Week in Month" column.