Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
I have data like below and it's direct fields from the source, I have created measures for Jan to Dec months.
If flaw_cnt is blank or 0 value need to replace it with my particular month measure or if it is <> 0 or Blank it has to load the actual value.
Solved! Go to Solution.
Hi @Akshay123 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a measure.
New Measure = IF(SUM('Table'[flaw_cnt])= BLANK() ||SUM('Table'[flaw_cnt])=0,[Yourmeasure],SUM('Table'[flaw_cnt]))
(3) Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Akshay123 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a measure.
New Measure = IF(SUM('Table'[flaw_cnt])= BLANK() ||SUM('Table'[flaw_cnt])=0,[Yourmeasure],SUM('Table'[flaw_cnt]))
(3) Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FLAW_CNT_REPLACE= if(flaw_cnt=blank() || flaw_cnt=0, [Your measeure for months],flaw_cnt)
Let me know if this helps
Hi @Kedar_Pande
Thanks for your response, it will not work.
My appoach I am looking, I need to validate all the months and return the value
for ex :
var a = if(month = 1, sum(flaw_cnt)
var b = if(month = 2, sum(flaw_cnt)
.
.
.
var c = if(month = 12, sum(flaw_cnt)
Return
if (a = 0, My measure, a)
But i am unable to return all months value
Hi @Kedar_Pande
Can't attach any files here, I have some limitations.
It's just like sales amout, which month how much of sales happend.
Till April have data, rest of the months are preductive count.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |