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 All
we are gettig data from the table for every month , if some month is missing we need add row . for example
Reading towards complaince / Monthly Frequency Target = complaince% ( >100% is equal to 100%)
for missing rows we need to consider 0/1 = 0 % , we need to aggregate fro year with 0 percentage for missing rows. how to achieve that
Solved! Go to Solution.
Hi @Surendra_thota,
These missing months don't exist, so let's create them. (Modeling -> New Table -> input this formula)
Date = DISTINCT ( SELECTCOLUMNS ( CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2017, 12, 31 ) ), "Month1", EOMONTH ( [Date], 0 ) ) )
Create a relationship from "Month1" to "month";
Then join the two tables together.
Table 2 = NATURALLEFTOUTERJOIN ( 'Date', 'Table1' )
Best Regards!
Dale
Hi @Surendra_thota,
Could you please mark the proper answer if it's convenient for you? That will be a help to others.
Best Regards!
Dale
Hi @Surendra_thota,
These missing months don't exist, so let's create them. (Modeling -> New Table -> input this formula)
Date = DISTINCT ( SELECTCOLUMNS ( CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2017, 12, 31 ) ), "Month1", EOMONTH ( [Date], 0 ) ) )
Create a relationship from "Month1" to "month";
Then join the two tables together.
Table 2 = NATURALLEFTOUTERJOIN ( 'Date', 'Table1' )
Best Regards!
Dale
I have a similar issue wherein I have to add missing seconds row as zero. What changes should be made to the DAX code.
Hi
You can do this in query editor (right click on the relevant column) and replace "null" with "0" as shown below.
Hope this helps
Then you can right the measure with IF function which will return 0 if your logic is not true.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |