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

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?