loop Statement to DAX

[nesrine]

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. 

 

[v-yulgu-msft]

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

[petrovnikitamai · Accepted solution]

new column = countx(filter('tableName';earlier([date])=[date]);[date])-3

try this

[Itsbibin]

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?

[nesrine]

petrovnikitamai Thank you very much