Forum Discussion
weekly data
Hi, I was assigned to recreate a spreadsheet entirely in Power BI What I want to acheive for example is with the number of tubulars toggling a data slider to switch between the numbers for exa...
I would need to know more about the toggle you are describing. Is it just the week ending date? If so, you could just create a matrix with the number of tubs on site and put the week ending date in a slicer. You then shouldn't need any calculations.
If your tubs broken out on a dialy basis, then you can probably consider a calculation along the lines of
CALCULATE(FactTable[Tubulars], ALLEXCEPT(DateTable,DateTable[WeekEndingDate]))
Currently it is a date tile slicer so what I am trying to acheive is clicking on 03/05/2024 is 2286, 26.4.2024 is 2578, 19.4.2024 is 2578 etc.