Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
new column = countx(filter('tableName';earlier([date])=[date]);[date])-3
try this
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
new column = countx(filter('tableName';earlier([date])=[date]);[date])-3
try this
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?