Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a report the data is structured (in Excel) as per example:
BuildingSite | EstimatedRepairDate | ActualRepairDate | EstimatedNumberofOffices |
Northeast | 8/1/2022 | 8/12/2022 | 5 |
Southeast | 9/10/2022 | 9/2/222 | 10 |
Central/midwest | 9/1/2023 | 50 | |
Southeast | 7/1/2021 | 9 | |
Southwest | 9/5/2022 | 9/5/2022 | 2 |
West | 8/1/2022 | 3 |
I tried creating a custom column that will calculate the completed number of offices based on ActualRepairDate is null
= Table.AddColumn("Completed Business Sites", each if [#"ActualRepairDate"] <> null then [#"EstimatedNumberofOffices"] else 0)
I'm getting error which is "Token Comma expected". When I click on show error, it really does not show anything. However the red line is right on [#"EstimatedNumberofOffices"] line.
I'm stumped and struggling with this.. Appreciate your help.
Solved! Go to Solution.
Hi @Anonymous ,
Try using the conditional column as below.
Hope this helps.
Did I help you today? Please accept my solution and hit the Kudos button.
You're most welcome. 😊
Hi @Anonymous ,
Try using the conditional column as below.
Hope this helps.
Did I help you today? Please accept my solution and hit the Kudos button.
Hi davehus,
I wrote it into the custom column.
Hi @Anonymous , is the measure above what you've actually written into the custom column or is it a copy from advanced editor?
Did I help you today? Please accept my solution and hit the Kudos button.
You have helped! Thank you so much. I have accepted your solution. It worked. Now I know how to do this going forward. Thank you again!!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
98 | |
89 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |