Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello my friends,
I have a question for you and I hope you can help me (as always) 🙂
I wrote a code:
Everything works perfect, but when I want to use this measure with other at one column chart it stops working. Is it because other measures have got diffrent date function? (no Date of witness)
Thank you for help all 🙂
@FILIPKACZMAR , You should push the hourly rate multiplcation at line level
Like
SUMX('SQA list 2022', 'SQA list 2022'[Total Duration ( Hours )] * related('Rates'[Hourly rate]) )
Also For Time intelligence, do not use .Date. Use Date Table and date without timestamp
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Helo, thanks for help and your time 🙂
Now I have got this error: Too few arguments were passed to the TOTALYTD function. The minimum argument count for the function is 2.
I am new at power bi, so maybe I miss something
@FILIPKACZMAR , Try like
TOTALYTD(
CALCULATE ( SUMX('SQA list 2022', 'SQA list 2022'[Total Duration ( Hours )] * related('Rates'[Hourly rate]) )),'Date'[Date]
)
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
In the picture you can see, that cos of noi gives two diffrent values 😞
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |