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 a table. And then do a substraction (for exemple here -3 to illustrate). And show the result ( coloun my result) in my dashboard depending on the selecting date. 

I have been thinking a lot, maybe ( loop would work but i don't know how to use loop on DAX. maybe ANOTHER SOLUTION.. ) 

THANK YOU VERY MUCH FOR YOUR HELP. 

 

 

Need Help

4 Replies

  • petrovnikitamai's avatar
    petrovnikitamai
    Resolver V
    7 years ago
    new column = countx(filter('tableName';earlier([date])=[date]);[date])-3

    try this

    • Itsbibin's avatar
      Itsbibin
      Regular Visitor
      2 years ago

      Hi petrovnikitamai 

       

      I have 2 table in my Power BI report B-Details and SPResult. SP result table is a stored procedure and will change dynamically with parameters. I want to create a new table from this in which it should filter Name and Country from B-Details and SPResult. Now after filtering this we have a uniquekey in B-Details. Now in the new table for each UniqueKey we have to get all the filtered values from SPResult table. So in the new table UniqueKey key row will be duplicated with as much rows we have in SPResult. Can you help me how to fix 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