Forum Discussion

nesrine's avatar
nesrine
Frequent Visitor
7 years ago
Solved

loop Statement to DAX

[ Spoiler ] Hello,   i'm new user of Power BI and i need your help! For my company, i need to know fo each date (weekly date), the number of line( number of application (here is type string)) in ...
Need Help
  • petrovnikitamai's avatar
    petrovnikitamai
    7 years ago
    new column = countx(filter('tableName';earlier([date])=[date]);[date])-3

    try this

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi nesrine,

 

Please refer to below measures:

NB rows = CALCULATE(COUNT(Table6[Application]),ALLEXCEPT(Table6,Table6[Date]))

My result = [NB rows]-3

 

Best regards,

Yuliana Gu