Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In a specific table, I have a date, and I use it in a segment graph
Then I have an other table with the following information :
[BillSales] 3
[Bill.StartDate] 4
[Bill.EndDate] 5
And I try to write this formula in Power BI
[BillSales] 3 * (Difference in days between (
(IF [Bill.EndDate] 5 - 1 day > 2 ; 2 ; [Bill.EndDate] 5 - 1 day)
AND
(IF [Bill.StartDate] 4 > [SegmentFilter.StartDate] 1; [SegmentFilter.StartDate] 1; [Bill.StartDate] 4 )
) + 1 day
) / (Difference in days between [Bill.EndDate] 5 and [Bill.StartDate] 4 + 1 day)
Many thanks for your help
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |