Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Tips and Tricks
Tutorial Requests
ExcelMonke's avatar
ExcelMonke
Impactful Individual
2 years ago

I may need a clearer picture of what it looks like in the PBIX to understand exactly what is going on. However, one thing you can try is using variables in your measure; consider the following:

Measure = 
VAR _StartDate = SELECTEDVALUE(Job Tacker[Arrival Date])
VAR _EndDate = SELECTEDVALUE(Job Tracker[Completed Date])

RETURN
CALCULATE(
SUM(Job Tracker[Tubular Quantity]),
DATESBETWEEN(Job Tracker[Date],_StartDate,_EndDate)
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Currently there is a date tile slicer 

    the card is below 

    what I am trying to accomplish is 

     

    Currently this does not work as clicking the date before 03/05/2024 the card displays 0, the date tile slicer is from a date table and calculated column. 

     

    Week Ending = 'tbl_Date'[Date]- MOD('tbl_Date'[Date]-1,7)+5