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.
Hi,
Is there a way to create a measure, but have conditions?
For example, I have created 10+ tables because I need my formula to filter out certain things based on Month, Year, or Internal/External Crews.
An example of a formula for External Crews in 2019 of December is:
Overall, I was wondering if there was a way to create my formulas in the Crew Productivity table, if possible, so I would not keep having to filter out from the Crew Productivity table, and continue to create more and more tables as time goes on...
Please let me know if this question is confusing...
Thank you!
Sarah
I think I did not get it completely. But to do any operation with time, create a calendar table. And join it with the date of you fact. Tell us what formula you want to drive(Functional not the power Bi formula)
In between refer
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
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
maybe to make it simpler, @amitchandak ,
i want to create a measure that says something like
"If month=December then use this measure, else if month=November, then use this measure, else if...."
For multiple conditions...
thank you!
Sarah
Hi @amitchandak,
I sort of did create a calendar table for each situation... for example, for External Crews for the month of December in 2019, this is the table I created:
If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |