The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everybody,
I have this doubt. I am using time intelligence and I did a task of getting the porcentual increase comparing the same period of the last year in two ways:
1. I create a new measure called "Utilidad" año Anterior:
Solved! Go to Solution.
Hi @Anonymous ,
According to your description, your error is because the “<alternateresult> ” in the DIVIDE function should be a number but not text. Here’s my solution.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
According to your description, your error is because the “<alternateresult> ” in the DIVIDE function should be a number but not text. Here’s my solution.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , POwer bi return blank when there is not data, but blank -1 = -1 , it not like null in database
In the second one try like
RETURN DIVIDE(Utilidad,UtilidadPeriodoAnterior,0)-1
I doubt the text creating a problem
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |