Forum Discussion
How to mark up a Powerbi List report
Hi there,
I have a powerBI report that is a list of all the jobs that we are currently doing. This report operates in direct query mode as the data is being pulled from a SQL Server.
During our month-end billing process, we need to mark up which of those jobs need to be billed out.
Essentially all im looking for is a method where I can have a spare column that lets someone input data saying yes or no.
Is this achieveable in powerBI?
Hi, saadat_rda
Try adding a measure written by dax to the report and use the IF function to calculate the result you want.
For reference:
Solved: Add custom column in Direct Query - Microsoft Fabric Community
Solved: add custom column to table - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-zhangtiCommunity Support
Hi, saadat_rda
Try adding a measure written by dax to the report and use the IF function to calculate the result you want.
For reference:
Solved: Add custom column in Direct Query - Microsoft Fabric Community
Solved: add custom column to table - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.