Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count of previous week

Hello all,   As im beginner with PBI, im coming to experts here. I have following issue: I have table with 2 columns (Target date and Status) in excel.   I want to create 2x DAX measures. ...
Need Help
  • AdaKAda's avatar
    AdaKAda
    3 years ago

    Try this: 
    Measure1 =
    CALCULATE (
    COUNTROWS ( YourTableName),
    FILTER (
    YourTableName,
    YourTableName[Status] in ({"In progress", "In Review", "Not started"})
    && WEEKNUM ( YourTableName[Target Date] )
    = WEEKNUM ( TODAY () )
    && YEAR ( YourTableName[Target Date] ) = YEAR ( TODAY () )
    ))

    Hopefully you can work out measure 2! 🙂 

AdaKAda's avatar
AdaKAda
Icon for Helper I rankHelper I
3 years ago

If the problem is blanks, this should do: 

Measure2 =
CALCULATE (
COUNTROWS ( YourTableName),
FILTER (
YourTableName,
YourTableName[Status] in ({"In progress", "In Review", "Not started"})
&& NOT

(WEEKNUM ( YourTableName[Target Date] ) = WEEKNUM ( TODAY () )
&& YEAR ( YourTableName[Target Date] ) = YEAR ( TODAY () ))

&& NOT(ISBLANK(financials[Date2]))
))

 
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for help AdaKAda . Much appreciated your support 🙂